1) Create the table partitioned as you want
2) Exchange partition
3) Drop your source table
4) Rename your new table to the desired table name (ALTER TABLE new_table RENAME TO source_table)
http://www.dbasupport.com/forums/sho...ange+partition
|
Results 1 to 10 of 13
Threaded View
|
Click Here to Expand Forum to Full Width |