exchange partition for moving data into history table [message #431078] |
Sat, 14 November 2009 08:02  |
swas_fly
Messages: 220 Registered: March 2008 Location: Bhubaneswar
|
Senior Member |
|
|
Hi All
I have a table temp_output
This table is monthly partitioned on entry_date.
I need to build a proces that will run monthly and will move data from temp_output to temp_output_history.
The table temp_output should contain 1-2 months of data.
and rest all should be moved to history table.
I think exchange partition will be the option for this.
Can anyone hint me a script that i can refer to build my requirement.
Thanks
|
|
|
|
|