|
-
You cannot shirk segments in undo tablespace. Fastest and safest way to accomplish this task is to create new undo tablespace with datafile size limit set as required.
Switch database to use new undo tablespace. Drop old undo tablespace if ok to do.
See Oracle9i DBA guide for details on managing undo tablespace in 9i.
Hope this helps.
Mohammad Zahid
Software Developer
Database Management Applications.
Vancouver, Canada
E-mail: [email protected]
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
|