-
how to enable undo_management=auto after i upgrade 8i to 10g now that spfile is used?
hi,
i hv upgraded my 8i test db to 10g. I wanted to switch to 10g's undo tablespace management and i hv created the undo tablespace...but i am at a lost how to switch the upgraded database to 10g's undo management as I cant seem to find a place to set the initialisation parameter UNDO_MANAGEMENT=AUTO as 10g is not using the text init.ora anymore...and i cant set it using 'Alter system set undo_management=auto' either it returns an error....wonder if anyone could help?
many thanks
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
|