SAP Knowledge Base Article - Preview

1954320 - ORA-00959 during table reorg

Symptom

A tablespace reorg using BR*Tools fails with the following error:

BR0280I BRSPACE time stamp: 2013-11-13 12.24.48
BR0301E SQL error -959 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_PK); END;'
ORA-00959: tablespace '_$deleted$10$0' does not exist
ORA-06512: at "SYS.DBMS_REDEFINITION", line 56
ORA-06512: at "SYS.DBMS_REDEFINITION", line 1490
ORA-06512: at line 1
BR0280I BRSPACE time stamp: 2013-11-13 12.24.48
BR1106E Reorganization of table <OWNER>.<TABLE_NAME> failed


Read more...

Environment

  • BR*Tools any version
  • Oracle any version
  • Any OS platform

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

drop dropped fail reorganization reorganize reorganizing migrating moving brtools br*tools dba administration administrative oracle move error abort deleted , KBA , BC-DB-ORA , Oracle , 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.