Why not split the partition, put the "old" data in it's own tablespace, make the tablespace that contains the "old" data as readonly.
This way, you don't have to worry about creating a join, etc.
|
Results 1 to 7 of 7
Thread: splitting the tableThreaded View
|
Click Here to Expand Forum to Full Width |