Dropping Datafiles
From: Patrick Elliott <pate_at_primenet.com>
Date: 1996/01/22
Message-ID: <4e0e29$6fr_at_nnrp1.news.primenet.com>#1/1
Date: 1996/01/22
Message-ID: <4e0e29$6fr_at_nnrp1.news.primenet.com>#1/1
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 Mon Jan 22 1996 - 00:00:00 CET