-
How about the UNDO tablespace, can i decrease the size ONLINE?
I have 2 datafiles in my UNDO tablespace, their sizes were 25GB each. I want it to trim down to 5GB each, can i do this ONLINE without shutting down the DB? if so, how can i do this?
-
Create a new undo tablespace, alter system set undo_tablespace *new tablespace* then drop the old one.
-
 Originally Posted by Harry_Potter
I have 2 datafiles in my UNDO tablespace, their sizes were 25GB each. I want it to trim down to 5GB each, can i do this ONLINE without shutting down the DB? if so, how can i do this?
yes, just resize the datafile downwards, and if it can resize it will
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
|