SAP Knowledge Base Article - Preview

2128162 - Errors due to terminated reorganization

Symptom

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:

Read more...

Keywords

KBA , BC-DB-ORA , Oracle , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.