Database Administration (MOSC)

MOSC Banner

UNDO Tablespace Issue

edited Dec 8, 2009 4:00PM in Database Administration (MOSC) 5 commentsAnswered

We have a 10.2.0.4 Database ..

We  have written a custom script which sends output in below format...and folks out here add datafile to undo tablespace..treating it as any other tablespace

But I wonder why one has to add datafiles to undo tablespace..it is managed automatically by oracle...

--Script Output---

Expired (GB) :4

Free Space in APPS_UNDOTS1 (GB) :1

Sum of Free Space and Expired (GB) : 5

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