Re: removing useless datafile

From: Bola Ogunlana <bolao_at_incads.demon.co.uk>
Date: Tue, 15 Sep 1998 16:18:39 +0100
Message-ID: <905874205.26205.0.nnrp-03.c2dec0b7@news.demon.co.uk>

try

alter database datafile '/m001/.../USER02.dbf' offline drop;

as long as you're sure the datafile contains no data ie. Don't forget to do your backup beforehand.

Shirley Donor wrote in message <6t9n99$gnc$1_at_paxfeed.eni.net>...
>
> We have a tablespace with 2 datafiles. one of the
> datafile is unnecessary and we like to
> delete it ? how do we go about it ?
>
> Example : Tablespace : USER
> Datafile : /m001/.../USER01.dbf
> /m001/.../USER02.dbf
>
> We like to remove USER02.dbf from the
> USER tablespace.
>
> Thanks.
>
>
Received on Tue Sep 15 1998 - 10:18:39 CDT