Re: Dropping undo datafiles while db up

From: David Sharples <davidsharples@xxxxxxxxx>
To: cemail_219@xxxxxxxxxxx
Date: Wed, 26 Oct 2005 15:09:39 +0100

you cant drop datafiles from a tablespace anyway (without dropping the
tablespace as well).
 However you can create a new undo tablespace for temporary work while you
do whatever it is you need to do

 On 10/26/05, J. Dex <cemail_219@xxxxxxxxxxx> wrote:
>
> Is there anyway to drop datafiles from an undo tablespace while the
> database
> is up (running in noarchivelog mode)? Or, do you have to startup nomount
> and alter database drop datafile?
>

Follow-Ups:

RE: Dropping undo datafiles while db up
From: Marquez, Chris

References:
- Dropping undo datafiles while db up
  - From: J. Dex

Re: Dropping undo datafiles while db up

Other related posts: