Converting from normal table to partition table [message #195570] |
Fri, 29 September 2006 08:46  |
swamy99
Messages: 30 Registered: June 2006
|
Member |
|
|
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  |
Frank Naude
Messages: 4596 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 ...;
|
|
|