Skip to Content
0
Former Member
Apr 30, 2014 at 05:05 AM

Tablespace reorg failing with error ORA-12008 and ORA-01555

711 Views

Hello,

We are reorganizing the tablespace in our PI System by BR tools.

System config is as below:

SAP Netweaver 7.

PI 7

Oracle 10g.

While doing the reorg of tablespace each time it fails on table SXMSCLUP with below error

BR0301E SQL error -12008 at location tab_onl_reorg-20, SQL statement:
'BEGIN DBMS_REDEFINITION.START_REDEF_TABLE (UNAME => '"SAPPIP"', ORIG_TABLE => '"SXMSCLUP"', INT_TABLE => '"SXMSCLUP#$"', OPTIONS_FLAG => DBMS_REDEFINITION.CONS_USE_PK); END;'
ORA-12008: error in materialized view refresh path
ORA-01555: snapshot too old: rollback segment number with name "" too small
ORA-22924: snapshot too old
ORA-06512: at "SYS.DBMS_REDEFINITION", line 50
ORA-06512: at "SYS.DBMS_REDEFINITION", line 1343
ORA-06512: at line 1
BR0280I BRSPACE time stamp: 2014-04-30 00.23.01
BR1106E Reorganization of table SAPPIP.SXMSCLUP failed

BR0280I BRSPACE time stamp: 2014-04-30 00.23.01
BR1141I 1 of 1 table processed - 1296545 of 1296545 rows done
BR0204I Percentage done: 100.00%, estimated end time: 0:23

I have taken care of space in new table space i.e :

Original tablespace size : 700 GB

Temporary tablespace created :700 GB.

Table SXMSCLUP size : approx 480 GB( including table+ LOBSEGMENT+ Index) - reorg fails on this table only.

PSAPUNDO : 80 GB

PSAPTEMP : 12 GB

Any help is appreciated