Re: Dynamic views

[Jay]

Title: Dynamic views

We have a different business case but you might want to look into materialized views.     ----- Original Message ----- From: david hill To: Multiple recipients of list ORACLE-L Sent: Wednesday, November 20, 2002 1:48 PM Subject: Dynamic views Hi Guys I'm trying to see if I can get around paying oracle $50,000 for partitioning I have a huge table and I want to partition it on date so I created 12 tables AAAA_JAN AAAA_FEB And so on But I want to create a view that will be used for inserting so it always Points to the current month without having to recreate the view every month. Is there anyway anybody can think of doing this? Thanks David Hill DBA Le Chateau