-
ORA-01552: Cannot use System Rollback For non-system tablespace
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.
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
-
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;
-nagarjuna
-
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
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
-
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.
An ounce of action is worth a ton of theory.
—Friedrich Engels
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|