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!

If you post personal information (name, email address etc.) you are agreeing to them being stored and displayed. Feel free to remain anonymous.