Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Wish to delete empty datafile

Wish to delete empty datafile

From: Linda Hagedorn <Linda_at_pets.com>
Date: Wed, 21 Jun 2000 09:48:08 -0700
Message-Id: <10535.110022@fatcity.com>


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 Received on Wed Jun 21 2000 - 11:48:08 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US