Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> 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 Received on Wed Jun 21 2000 - 11:48:08 CDT