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.
SAP Knowledge Base Article - Preview