Title: Dynamic views
We have a different business case but you might want to look into materialized views.
 
 
----- Original Message -----
From: david hill
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

Reply via email to