Viswamitra's blog

I have started the redefinition of the table after cancelling the previous one due to some error. But I was getting the below error.

BEGIN
DBMS_REDEFINITION.START_REDEF_TABLE(
   uname        => user,
   orig_table   => ‘parent’,
   int_table    => ‘parent_interim’,
   col_mapping  => NULL,
   options_flag => DBMS_REDEFINITION.CONS_USE_ROWID
   );
END;
/  2    3    4    5    6    7    8    9   10
BEGIN
*
ERROR at line 1:
ORA-23539: table “TEST”.”PARENT” currently being redefined
ORA-06512: at “SYS.DBMS_REDEFINITION”, line 52
ORA-06512: at “SYS.DBMS_REDEFINITION”, line 1646
ORA-06512: at line 2

This means the previous processes was not canceled and it is running in the background.

Execute the below command , this will stop the process.

BEGIN
DBMS_REDEFINITION.abort_redef_table(
uname      => ‘TEST’,
orig_table => ‘parent’,
int_table  => ‘parent_interim’);
END;
/