ORA-01552: Cannot use System Rollback For non-system tablespace

[gaegoori]

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?

[abhaysk]

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.

[gaegoori]

I have those set in my init.ora

[nagarjuna]

Just see the output of the following query and see whether you get non system rollback segments listed.

select * from v$rollname;

[abhaysk]

Originally posted by gaegoori
I have those set in my init.ora

U said u created UNDO TBS right....

then i suppose u need to bounce DB, for changes to be effective.

Abhay

[adrianomp]

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.