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.