RE: UNDO TABLESPACE

From: Sam Chakkanat <cvsam_at_cox.net>
Date: Wed, 29 Nov 2006 18:58:37 -0800
Message-ID: <000e01c7142b$6edaf0e0$6d01a8c0@IBM839YQP>

Seems like you are using automatic UNDO? Logically, you could do this by changing the UNDO
to manual first, by creating other rollback segments on another tablespace. Once you transfer
all the transactions to use the new rollbacks you could take the UNDO tablespace down and recreate.

But just a thought - Why do you need to re-create the UNDO?

Any comments geeks?

Sam.
-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Dean Paul
Sent: Wednesday, November 29, 2006 6:37 PM To: oracle-l_at_freelists.org
Subject: UNDO TABLESPACE

Hi,

I want to drop undo tablespace.
and recreate it.What would be best way?
Thanks

---

Fixing up the home? Live Search can help http://imagine-windowslive.com/search/kits/default.aspx?kit=improve&locale=e n-US&source=hmemailtaglinenov06&FORM=WLMTAG

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Wed Nov 29 2006 - 20:58:37 CST