Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Flushing UNDO TABLESPACE

j_DBA_souravApr 21 2011 — edited Nov 16 2012

Hi all,

Our application team is running a query which deletes almost 50 million data at a time. So expectedly Undo tablespace is filled up completely and for oracle's basic property it is failing the query...

I don't want to increase the size of UNDO TBS.. I can't afford to do it..

Can I flush the Undo tablespace by any chance... ?

Or suggest me a way...

Thanks and Regards,
Saha

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 14 2012

Added on Apr 21 2011

#general-database-discussions

7 comments

31,569 views