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.
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