Partioning existing tables in 12c
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.