RE: Dropping undo datafiles while db up
- From: "Christian Antognini" <Christian.Antognini@xxxxxxxxxxxx>
- To: <davidsharples@xxxxxxxxx>
- Date: Wed, 26 Oct 2005 16:34:05 +0200
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)
--
//www.freelists.org/webpage/oracle-l
Other related posts:
