RE: Wish to delete empty datafile

First, is just the datafile empty or is the entire tablespace that the datafile is part of empty? If the former, then you can't just delete the datafile. The most you can do is resize it to a very small size. If the latter, then drop the tablespace. You may then remove the datafile on the OS level.

The view to look at to see what tablespace it belongs to (and if there are any other datafiles associated with it) is dba_data_files.

-----Original Message-----
From: Linda Hagedorn [mailto:Linda_at_pets.com] Sent: Wednesday, June 21, 2000 2:04 PM
To: Multiple recipients of list ORACLE-L Subject: Wish to delete empty datafile

Hello,

I want to confirm a dataset is empty, and drop it from the database. Does someone have a query showing a dataset is unused, that is to say, contains no data whatsoever.

I have just finished reducing a production database to a test/development size (many thanks Joe!, Eric, and the list). I reduced it so much, I'm able to delete a user02.dbf dataset (after I confirm it is empty).

Any assistance is appreciated.

Thanks, Linda

-- 
Author: Linda Hagedorn
  INET: Linda_at_pets.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).