Re: Dropping undo datafiles while db up

  • From: Alex Gorbachev <gorbyx@xxxxxxxxx>
  • To: cmarquez@xxxxxxxxxxxxxxxx
  • Date: Thu, 27 Oct 2005 07:56:59 +0200

> >> replace an undo tablespace with another undo
> >> tablespace while the instance is running.
> I gave similar advise but from old RBS perspective.
> But he actually and literary might just want to drop a single datafile
> (rather than create a new)?
> Which can not be done in <= 9i, but I see here in another post can be done
> in 10G R2.
Yep. The only way to do it in 9i is to switch UNDO tablespace to
another one and recreate the old TS. One might need to wait up to
retention_period time to drop this old UNDO TS though.

Best regards,
Alex Gorbachev

Other related posts: