2128162 - Errors due to terminated reorganization

During online reorganization with BRSPACE several activities are performed by BRSPACE. Such as the following:

• Creating the target table with the naming convention <source_table>#$.
• Creating indexes on the target table in accordance with the naming convention <source_index>#$.

In the end, these objects are removed. However, if the reorganization has terminated before BRSPACE was unable to connect to the database during the final phase to remove the temporary objects, for example due to a dump.

Next organization might end with the following errors:

1. BR0301E SQL error -3113 in thread 1 at location tab_onl_reorg-63, SQL statement:
   'BEGIN DBMS_REDEFINITION.FINISH_REDEF_TABLE (UNAME => '"<OWNER>"',ORIG_TABLE => '"<TABLE_NAME>"', INT_TABLE => '"<TABLE_NAME>#$"'); END;'
   ORA-03113: end-of-file on communication channel
   Process ID: *****
   Session ID: ***** Serial number: *****
   BR0280I BRSPACE time stamp:
   BR0301W SQL error -3114 at location BrReorgCleanup-2, SQL statement:
   *************************
   ORA-03114: not connected to ORACLE
    
2. BR0301W SQL error -42030 at location BrReorgCheck-7, SQL statement:
   'BEGIN DBMS_REDEFINITION.CAN_REDEF_TABLE (UNAME => '"<OWNER>"', TNAME =>'"<TABLE_NAME>"', OPTIONS_FLAG => DBMS_REDEFINITION.CONS_USE_PK); END;'
   ORA-42030: cannot online redefine table "<OWNER>"."<TABLE_NAME>" with commit
   SCN-based MV log
   ORA-06512: at "SYS.DBMS_REDEFINITION", line 143
   ORA-06512: at "SYS.DBMS_REDEFINITION", line 1627
   ORA-06512: at line 1
   BR1111I Reorganization of table <OWNER>.<TABLE_NAME> will be skipped
    
3. BR0301W SQL error -12091 at location BrReorgCheck-5, SQL statement:
   'BEGIN DBMS_REDEFINITION.CAN_REDEF_TABLE (UNAME => '"<OWNER>"', TNAME=> '"<TABLE_NAME>"', OPTIONS_FLAG => DBMS_REDEFINITION.CONS_USE_PK); END;'
   ORA-12091: cannot online redefine table "<OWNER>"."<TABLE_NAME>" with
   materialized views
   ORA-06512: at "SYS.DBMS_REDEFINITION", line 137
   ORA-06512: at "SYS.DBMS_REDEFINITION", line 1478
   ORA-06512: at line 1
   BR1111I Reorganization of table <OWNER>.<TABLE_NAME> will be skipped
    
4. BR0301E SQL error -20000 at location tab_onl_reorg-39, SQL statement:
   'BEGIN DBMS_REDEFINITION.START_REDEF_TABLE (UNAME => '"<OWNER>"',
   ORIG_TABLE => '"/SDF/RBE_CTRL_A"', INT_TABLE => '"<TABLE_NAME>#$"',
   OPTIONS_FLAG => DBMS_REDEFINITION.CONS_USE_PK); END;'
   ORA-20000: Trigger xdb_installation_trigger does not support object creation of type SNAPSHOT LOG
   ORA-06512: at line 36
   ORA-06512: at "SYS.DBMS_REDEFINITION", line 56
   ORA-06512: at "SYS.DBMS_REDEFINITION", line 1488
    
5. BR0301E SQL error -42012 at location tab_onl_reorg-42, SQL statement:
   'BEGIN DBMS_REDEFINITION.FINISH_REDEF_TABLE (UNAME => '"<OWNER>"',
   ORIG_TABLE => '"<TABLE_NAME>"', INT_TABLE =>'"<TABLE_NAME>#$"'); END;'
   ORA-42012: error occurred while completing the redefinition
   ORA-00955: name is already used by an existing object
   ORA-06512: at "SYS.DBMS_REDEFINITION", line 76
   ORA-06512: at "SYS.DBMS_REDEFINITION", line 1377
   ORA-06512: at line 1
   BR0280I BRSPACE time stamp:
   BR1106E Reorganization of table OWNER.TABLE_NAME failed
   BR0280I BRSPACE time stamp:

KBA , BC-DB-ORA , Oracle , Problem