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?
>

Other related posts: