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

BR0301E, tab_onl_reorg, BEGIN DBMS_REDEFINITION.START_REDEF_TABLE, ORA-00959, BR1106E, 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 , 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.