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.
DO NOT ask technical questions here! They will be deleted!
These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!