Database DataWarehousing (MOSC)

MOSC Banner

DBMS_REDEFINITION to partition a non partitioned table

edited Apr 22, 2013 10:17PM in Database DataWarehousing (MOSC) 5 commentsAnswered
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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center