RE: Dropping undo datafiles while db up

From: Christian Antognini <Christian.Antognini_at_trivadis.com>
Date: Wed, 26 Oct 2005 16:34:05 +0200
Message-ID: <F2C9CCA71510B442AF71446CAE8AEBAF1BBD69@MSXVS04.trivadis.com>

David

> you cant drop datafiles from a tablespace anyway (without dropping the tablespace as well).

As of 10g R2 it's possible to execute the following statement...

ALTER TABLESPACE <tablespace> DROP DATAFILE <datafile>

Of course this is only possible if the datafile is empty.

Regards,
Chris

New Features Oracle Database 10g Release 2 seminars @ www.trivadis.com <http://www.trivadis.com> Italiano: Lugano (24-Nov)
Français: Genève (17-Nov)
Deutsch: Düsseldorf (23-Nov), Zürich (29-Nov), Stuttgart (13-Dec)

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

Received on Wed Oct 26 2005 - 09:40:10 CDT