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'

is undotbs1 online and working

Hi,

The db was in read only mode....so i was getting this error.

But i guess it is completely a misleading message.......

thx.