OraFAQ Forum: Server Administration » undo tablespace 100% full with offline extendes

Home » RDBMS Server » Server Administration » undo tablespace 100% full with offline extendes (oracle 10g R2 , Cluster , ASM , Windows 2003 server)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

undo tablespace 100% full with offline extendes [message #467700]

Mon, 26 July 2010 15:01

RAY_HT
Messages: 155
Registered: May 2005
Location: Giza

Senior Member

Hi All ,
i'm facing a problem while i'm inserting millions of record from table to table that undo tablespace reach 100% full and execution aborted.
Now , how can free the undo tablespace ??? many of extendes are offline.
will it flush automatically ??? or what i should do ?

thanks

Report message to a moderator

Re: undo tablespace 100% full with offline extendes [message #467701 is a reply to message #467700]

Mon, 26 July 2010 15:02

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>or what i should do ?
add an additional file to the tablespace

Report message to a moderator

Re: undo tablespace 100% full with offline extendes [message #467709 is a reply to message #467701]

Mon, 26 July 2010 16:12

RAY_HT
Messages: 155
Registered: May 2005
Location: Giza

Senior Member

it's not permenent tablespace , it's an undo tablespace loaded by uncommitted transactions .

will it flush itself when database shutdown and restart?

regards

Report message to a moderator