ORA-01552 cannot use system rollback segment for non-system tablespace
1008501May 13 2013 — edited May 14 2013Hello
First of all I am an absolute amateur on Oracle databases. Company that we care have a program that runs on oracle database. At the moment the program is not working properly because when they trying to save documents in aplication there is an error "ORA-01552 cannot use system rollback segment for non-system tablespace"
This problem appeared in the forum, but I can’t understand all of the instructions that are given. Please Help me.
This is what I be able to check. And everything look good.
Total System Global Area 149495776 bytes
Fixed Size 454624 bytes
Variable Size 113246208 bytes
Database Buffers 33554432 bytes
Redo Buffers 2240512 bytes
Database mounted.
Database opened.
1. SQL> show parameter undo
NAME TYPE VALUE
------------------------------------ ----------- ---------
undo_management string AUTO
undo_retention integer 900
undo_suppress_errors boolean FALSE
undo_tablespace string UNDOTBS1
2. SQL> select file#,status from v$datafile;
FILE# STATUS
---------- -------
1 SYSTEM
2 ONLINE
3 ONLINE
4 ONLINE
5 ONLINE
6 ONLINE
7 ONLINE
8 ONLINE
9 ONLINE
10 ONLINE
3. SQL> select segment_name, tablespace_name, initial_extent,status from dba_rollback_segs;
SEGMENT_NAME TABLESPACE_NAME INITIAL_EXTENT
------------------------------ ------------------------------ --------------
STATUS
----------------
SYSTEM SYSTEM 106496
ONLINE
_SYSSMU1$ UNDOTBS1 131072
ONLINE
_SYSSMU2$ UNDOTBS1 131072
ONLINE
SEGMENT_NAME TABLESPACE_NAME INITIAL_EXTENT
------------------------------ ------------------------------ --------------
STATUS
----------------
_SYSSMU3$ UNDOTBS1 131072
ONLINE
_SYSSMU4$ UNDOTBS1 131072
ONLINE
_SYSSMU5$ UNDOTBS1 131072
ONLINE
SEGMENT_NAME TABLESPACE_NAME INITIAL_EXTENT
------------------------------ ------------------------------ --------------
STATUS
----------------
_SYSSMU6$ UNDOTBS1 131072
ONLINE
_SYSSMU7$ UNDOTBS1 131072
ONLINE
_SYSSMU8$ UNDOTBS1 131072
ONLINE
SEGMENT_NAME TABLESPACE_NAME INITIAL_EXTENT
------------------------------ ------------------------------ --------------
STATUS
----------------
_SYSSMU9$ UNDOTBS1 131072
ONLINE
_SYSSMU10$ UNDOTBS1 131072
ONLINE
11 rows selected.