-
Remove auto undo management
Hi
I need to do an import which needs a manual undo management. I have alaredy uncommented it during the creation of my database, but it still appears!
How do I modify it? I do see my init(sid).ora file in $ORACLE_HOME/dbs...only the spfile which cannot be modified directly right? Any help please?
Many thanks!
-
alter system set undo_management = manual scope = both
-
well if youw ant to feel in control
create pfile from spfile;
move your spfile away for the moment and change your now new pfile to have what you want, then what you want it to use the spfile again, just move it back in
-
Great! Thanks!
-
Donot forget to create user defined rollback segment
Donot forget to create user defined rollback segment after setting
sql> alter system set undo_management=manual
if users want to any transaction it needs rollback segs
J Gangadhar
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
|