Home » SQL & PL/SQL » SQL & PL/SQL » Converting from normal table to partition table
Converting from normal table to partition table [message #195570] Fri, 29 September 2006 08:46 Go to next message
Messages: 30
Registered: June 2006
I have a normal table that has been created and have data in it. Is there a way to convert this table into partition table? OR create another partition table and move the data into that newly created partitioned table?
Re: Converting from normal table to partition table [message #195681 is a reply to message #195570] Sun, 01 October 2006 02:53 Go to previous message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
The easiest would be to create a new partitioned table, copy the data across, drop the old table and rename the partitioned table.

If you need to do it on-line, look at the DBMS_REDEFINITION package.

Another approach is to create a partitioned table and swap the table in as a partition of the new partitioned table. Command is: alter table ... exchange partition ... with table ...;
Previous Topic: getting kup-00554 when creating external table
Next Topic: Merge Statement
Goto Forum:

Current Time: Wed Oct 26 06:29:06 CDT 2016

Total time taken to generate the page: 0.08946 seconds