Database Administration (MOSC)

MOSC Banner

Undo tablespace way to large

edited Jun 15, 2011 4:40AM in Database Administration (MOSC) 10 commentsAnswered
 I have a situation where my undo tablespace has grown large and needs to be dealt with before we run out of space on the drive.  The actions I plan to take are:

Create a new undo tablespace on a different drive

Create undo tablespace UNDOTBS2 datafile 'E:\.......\.....\undotbs2.ora' size 50m autoextend on;

Then I will switch the undo tablespaces

Alter system set undo_tablespace = undotbs2;

Then I will wait for the old tablespace to stop being used

Here is where I need to ask a question

I read that I can drop the old tablespace since the new one will now be used.  Can I also drop the datafile along with it?  This is a production database and I need to reclaim that space and believe this is the correct action, but need it to be confirmed.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center