I'm getting following error when user tries to insert.
ORA-01552: Cannot use System Rollback For non-system tablespace
I created UNDO Tablespaces and I checked my RBS and there is only SYSTEM RBS. Is this right or do I need to create another RBS? I thought UNDO TS supposed to take care all this in 9i?
In init pramaeters u nned to specify
undo_management=AUTO
undo_tablespace=UNDO_TBS_Name
and i think u need to bounce ur DB for changes to be effective
abhay.
I have those set in my init.ora
Just see the output of the following query and see whether you get non system rollback segments listed.
select * from v$rollname;
U said u created UNDO TBS right....Quote:
Originally posted by gaegoori
I have those set in my init.ora
then i suppose u need to bounce DB, for changes to be effective.
Abhay
If you have just one undo tablespace it's not necessary to specify it, Oracle can automatically find the first one available and use it.
Just assure that UNDO_MANAGEMENT is set to AUTO.