Friday, April 26, 2013

Creating Partition on existing table?

We cannot create a partition on existing non partition table.
If you try to create a partition on non partition table you will get below error.

ORA-14020: this physical attribute may not be specified for a table partition

We can create a partition using below method.

step 1: Create new table same as source table with partition
step2: insert the data from source table to partition table.
step3: drop the source table.
step4: Rename the partition table as source table name.


No comments:

Post a Comment