SAP Knowledge Base Article - Preview

1971955 - ORA-23539 during reorganization - NetWeaver

Symptom

When running a reorganization with BRSPACE, it fails with the error below:

ORA-23539: table <table> currently being redefined
ORA-06512: at "SYS.DBMS_REDEFINITION", line 143
ORA-06512: at "SYS.DBMS_REDEFINITION", line 1625
ORA-06512: at line 1
BR1111I Reorganization of table <table> will be skipped


Read more...

Environment

  • Any SAP system
  • No Oracle version restriction
  • No platform restriction

Product

SAP NetWeaver 2004 ; SAP NetWeaver 7.0 ; SAP NetWeaver 7.1 ; SAP NetWeaver 7.2 ; SAP NetWeaver 7.3 ; SAP NetWeaver 7.4 ; SAP NetWeaver 7.5 ; SAP enhancement package 1 for SAP NetWeaver 7.0 ; SAP enhancement package 1 for SAP NetWeaver 7.3 ; SAP enhancement package 2 for SAP NetWeaver 7.0 ; SAP enhancement package 3 for SAP NetWeaver 7.0

Keywords

rdbms redef reorganisation rebuild , KBA , BC-DB-ORA-DBA , Database Administration , 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.