Comments
| 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.Cheers Tim... |
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, that's what my forum is for!
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!