Primary key: exec DBMS_REDEFINITION.CAN_REDEF_TABLE('TEST','TEST'); exec DBMS_REDEFINITION.START_REDEF_TABLE('TEST','TEST','TEST_TMP'); declare error_count pls_integer := 0; BEGIN dbms_redefinition.copy_table_dependents('TEST', 'TEST', 'TEST_TMP',1, true,true,true,false,error_count); dbms_output.put_line('errors := ' || to_char(error_count)); END; / exec DBMS_REDEFINITION.SYNC_INTERIM_TABLE('TEST', 'TEST', 'TEST_TMP'); exec DBMS_REDEFINITION.FINISH_REDEF_TABLE('TEST', 'TEST', 'TEST_TMP'); ROWID: exec DBMS_REDEFINITION.CAN_REDEF_TABLE('TEST','TEST',2); exec DBMS_REDEFINITION.START_REDEF_TABLE('TEST','TEST','TEST_TMP',options_flag=>dbms_redefinition.cons_use_rowid); declare error_count pls_integer := 0; BEGIN dbms_redefinition.copy_table_dependents('TEST', 'TEST', 'TEST_TMP',1, true,true,true,false,error_count); dbms_output.put_line('errors := ' || to_char(error_count)); END; / exec DBMS_REDEFINITION.SYNC_INTERIM_TABLE('TEST', 'TEST', 'TEST_TMP'); exec DBMS_REDEFINITION.FINISH_REDEF_TABLE('TEST', 'TEST', 'TEST_TMP');