ORA-23540 - Oracle 11gR2 RAC - Database ORA-23540 on SYNC_INTERM_TABLE or FINISH_REDEF_TABLE - NO PA

BEGIN

   DBMS_REDEFINITION.start_redef_table (

      uname       => 'USER',

      orig_table  => 'T1',

      int_table   => 'T1_PART',

      options_flag => DBMS_REDEFINITION.cons_use_pk);

END;

/

--> ok

SELECT COUNT(*) FROM USER.T1 --> 100.000.000

SELECT COUNT(*) FROM USER.T1_PART ---> 99.999.99X

select count(9) from  USER.MLOG$_T1; ---> X

BEGIN

   DBMS_REDEFINITION.SYNC_INTERIM_TABLE('USER', 'T1', 'T1_PART');

END;

/

ERROR: [Error] Execution (4: 1): ORA-23540

SET SERVEROUTPUT ON;

DECLARE

   num_errors     PLS_INTEGER;

BEGIN

   DBMS_REDEFINITION.COPY_TABLE_DEPENDENTS (

      uname       => 'USER',

      orig_table  => 'T1',

      int_table   => 'T1_PART',

      copy_indexes => 1,

      copy_triggers => TRUE,

      copy_constraints => TRUE,

      copy_privileges => TRUE,

      ignore_errors => TRUE,