Re: Dropping Datafiles
From: Ken Friday <ken.friday_at_teldta.com>
Date: 1996/01/22
Message-ID: <4e0k2p$ins_at_madison.tdsnet.com>#1/1
Date: 1996/01/22
Message-ID: <4e0k2p$ins_at_madison.tdsnet.com>#1/1
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.
Patrick,
You'll have to drop the tablespace at this point in time Oracle does not
allow for the manipulation of files (aside from adding/moving them).
Future releases are supposed to allow for resizing.
Ken F.
-- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~Received on Mon Jan 22 1996 - 00:00:00 CET