David,
How about Dynamic SQL in an Instead Of trigger?
Jack C. Applewhite
Database Administrator
Austin Independent School District
Austin, Texas
512.414.9715 (wk)
512.935.5929 (pager)
[EMAIL PROTECTED]
david hill
<david.hill@lec To: Multiple recipients of list ORACLE-L
hateau.ca> <[EMAIL PROTECTED]>
Sent by: cc:
[EMAIL PROTECTED] Subject: Dynamic views
m
11/20/2002
12:48 PM
Please respond
to ORACLE-L
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
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
