Re: Dropping Datafiles
From: Michael Abbey <msabbey_at_magi.com>
Date: 1996/01/23
Message-ID: <4e1he8$dpc_at_news.magi.com>#1/1
Date: 1996/01/23
Message-ID: <4e1he8$dpc_at_news.magi.com>#1/1
Unfortunately there is no way to drop a datafile from a tablespace other than exporting the data, dropping the datafiles, then recreating the tablepsace WITHOUT the offending datafile.
Michael
pate_at_primenet.com (Patrick Elliott) wrote:
>I need to remove some datafiles from tablespaces in oracle that I know are not
>in use by any tablespaces. I have tried:
>ALTER DATABASE
>DATAFILE '<filename>' OFFLINE DROP;
>but this doesn't work. The tablespaces still report the datafiles in use.
>Any help on this matter would be appreciated.
Received on Tue Jan 23 1996 - 00:00:00 CET