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 , Problem

About this page

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

Search for additional results

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