|Partitioning an Existing Table using EXCHANGE PARTITION - This article presents a simple method for partitioning an existing table using the EXCHANGE PARTITION syntax.|
Robert A G Cook said...RENAME big_table2 TO big_table; doesn't work on 10R2 installed on Solaris x86. It generates:
ERROR at line 1:
ORA-03001: unimplemented feature
To rename big_table2, I had to use
alter table big_table2
rename to big_table;
That works just fine.
Thanks for your excellent example of EXCHANGE PARTITIONING.
Tim... said...I'm guessing you're not using SQL*Plus to do this.
Tony said...Nice one - thanks.
although the fact that I'm doing this in 2008 caused concern when my 2005 partition showed up empty! Adding PARTITION big_table_2008 solved it.