RE: UNDO TABLESPACE
- From: "Sam Chakkanat" <cvsam@xxxxxxx>
- To: <oracledbam@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 29 Nov 2006 18:58:37 -0800
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Dean Paul
Sent: Wednesday, November 29, 2006 6:37 PM
To: oracle-l@xxxxxxxxxxxxx
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
