DBMS_REDEFINITION to partition a non partitioned table
Hi
We are converting a non partitioned table to a partitioned table. This is a 11.2.0.3 database
We are using DBMS_REDEFINITION to accomplish that
The original table has 3 indices.. 2 are normal indexes and 1 is UNIQUE index / Primary Key
Here is what we did
Step 1 )
EXEC Dbms_Redefinition.Can_Redef_Table('APPS','ORIG_TABLE');
.. success
Step 2)
Create interim table INT_TABLE with exact the same structure as ORIG_TABLE but without the PK CONSTRAINT
Step 3) exec DBMS_REDEFINITION.start_redef_table('APPS','ORIG_TABLE','INT_TABLE');
......Completed successfully
Now, as we mentioned, the original table has 3 indexes.. 2 are non unique consisting of single column and 1 is unique / primary key
We are converting a non partitioned table to a partitioned table. This is a 11.2.0.3 database
We are using DBMS_REDEFINITION to accomplish that
The original table has 3 indices.. 2 are normal indexes and 1 is UNIQUE index / Primary Key
Here is what we did
Step 1 )
EXEC Dbms_Redefinition.Can_Redef_Table('APPS','ORIG_TABLE');
.. success
Step 2)
Create interim table INT_TABLE with exact the same structure as ORIG_TABLE but without the PK CONSTRAINT
Step 3) exec DBMS_REDEFINITION.start_redef_table('APPS','ORIG_TABLE','INT_TABLE');
......Completed successfully
Now, as we mentioned, the original table has 3 indexes.. 2 are non unique consisting of single column and 1 is unique / primary key
0