Re: Drop UNDO tablespace

Tom,

Thanks for your response. We did bounce the particular instance but not the entire database.I just wanted to check with experts over here before I submit a SR.

Thanks
Sami

On 6/6/06, Mercadante, Thomas F (LABOR)
<Thomas.Mercadante_at_labor.state.ny.us> wrote:
> Sami,
>
> Have you bounced the database since you created the new UNDO tablespace?
> It might clear out the old undo so that you can drop it.
> Short of that, I would submit an SR to Oracle support and see what they
> have to say.
>
> Tom

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