Hey Gurus,
I am coming out on the tail end of our production database upgrade from 9.2.0.8 to 10.2.0.3 and I'm getting this ORA-01552 error...I ran the following sql:
select segment_name, tablespace_name, initial_extent,status
2 from dba_rollback_segs;
and my output is says something to the effect of:
SEGMENT_NAME TABLESPACE_NAME INITIAL_EXTENT STATUS
------------------------------ ------------------------------ -------------- ----------------
SYSTEM SYSTEM 114688 ONLINE
_SYSSMU1$ UNDOTBS1 131072 ONLINE
_SYSSMU35$ UNDOTBS2 131072 ONLINE

I didn't paste them all in here because there were too many..but I place enough so that ya'll can see how many tablespaces I have for undo...

I also did a show parameter undo and here's the output:
SQL> show parameter undo

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_management string AUTO
undo_retention integer 900
undo_tablespace string UNDOTBS2

I'm on an AIX 64bit 5.3 GPFS 2 node Rac cluster....can you gurus help me out a little here...I want to make sure that what I think I need to do is what you guys think...

Thanks,
Nate

Oracle LazyDBA home page