ORA-01552 cannot use system rollback segment
Hi,
I am trying to dml on my db (10.2 version)
getting the following error.
SQL> show parameter undo
NAME TYPE VALUE
------------------------------------ ----------- ----
undo_management string AUTO
undo_retention integer 900
undo_tablespace string UNDOTBS1
SQL> connect scott/tiger
Connected.
SQL> insert into tab1 values(2,'RAM');
insert into tab1 values(2,'RAM')
*
ERROR at line 1:
ORA-01552: cannot use system rollback segment for non-system tablespace 'USERS'
------------------------------------------------------------------------
The most enjoyable things in the world are either Immoral or too Expensive or otherwise Inaccessible anyway
Reply With Quote