Database DataWarehousing (MOSC)

MOSC Banner

Partioning existing tables in 12c

edited Feb 8, 2016 11:36AM in Database DataWarehousing (MOSC) 2 commentsAnswered

Greetings,

I am attempting to partition an existing Large table in Oracle 12c (12.1.02).  Following the instructions from 472449.1:

I get a list of the dependencies, create the interim table, add constraints.

I ran DBMS_REDEFINITION.can_redef_table with no errors.

I ran DBMS_REDEFINITION.copy_table_dependents with the following:

     copy_indexes => DBMS_REDEFINITION.cons_orig_params,

     copy_triggers=> TRUE,

     copy_constraints=> TRUE,

     copy_privileges=>TRUE,

     ignore_errors => FALSE,

     copy_statistics => FALSE,

     copy_mvlog => FALSE


It ran with no errors.  I see the tmp primary keys, foreign keys, triggers, and function based indexes.  The only thing I seem to be missing are Views and 1 Procedure.

Tagged:

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