SAP Knowledge Base Article - Preview

2385979 - ORA-04021 on table reorganization

Symptom

While carrying out an online table reorganization with BRSPACE, errors like the following occur:

BR0301E SQL error -4021 at location tab_onl_reorg-39, SQL statement:
'BEGIN DBMS_REDEFINITION.START_REDEF_TABLE (UNAME => '"<OWNER>"', ORIG_TABLE => '"<TABLE_NAME>"', INT_TABLE => '"<TABLE_NAME>#$"', OPTIONS_FLAG => DBMS_REDEFINITION.CONS_USE_ROWID); END;'
ORA-04021: timeout occurred while waiting to lock object
ORA-06512: at "SYS.DBMS_REDEFINITION", line 56
ORA-06512: at "SYS.DBMS_REDEFINITION", line 1498
ORA-06512: at line 1
BR0280I BRSPACE time stamp:
BR1106E Reorganization of table OWNER.TABLE_NAME failed

OR

BR0301E SQL error -42012 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-42012: error occurred while completing the redefinition
ORA-04021: timeout occurred while waiting to lock object
ORA-06512: at "SYS.DBMS_REDEFINITION", line 82
ORA-06512: at "SYS.DBMS_REDEFINITION", line 1532
ORA-06512: at line 1
BR0280I BRSPACE time stamp:
BR1106E Reorganization of table OWNER.TABLE_NAME failed


Read more...

Environment

  • SAP systems with Oracle database
  • Not restricted to a product or product version

Keywords

ORA-4021 time out reorg tbreorg , KBA , BC-DB-ORA-DBA , Database Administration with 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.