8i | 9i | 10g | 11g | 12c | 13c | 18c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Misc » Here

Comments for Partitioning an Existing Table using EXCHANGE PARTITION

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!