Forums | Aggregator | Books | Industry News | Firefox Plugins | Social | Links


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.

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!

Add your comments here.
(max 400 chars - plain text)