RE: table partitions and views
Date: Mon, 12 Jan 2009 14:51:46 -0800
Message-ID: <02be01c97508$5a9ac390$0fd04ab0$_at_net>
Michael.Coll-Barth_at_VerizonWireless.com wrote:
> ...I have two scheams with numerous tables, each with partitions based on
> a date. The second parition starts with this year's data for a new group
> that was formed. I'd like to make queries automagically pull data from
> a table in the original schema if the query uses a date prior to the
> start of the year.
Strictly speaking, the way to do this within the relational model would have been to add a column to the partitioned table for "group" (whatever that is) rather than create a new schema.
I suppose you could create a union all view across the two tables.
Or maybe this is logic more appropriately handled within the application.
Regards,
Jeremiah Wilton
ORA-600 Consulting
http://www.ora-600.net
http://oradeblog.blogspot.com
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Jan 12 2009 - 16:51:46 CST