RE: Wish to delete empty datafile

From: Gesler, Richard <rgesler_at_lsfi.com>
Date: Wed, 21 Jun 2000 13:55:37 -0400
Message-Id: <10535.110039@fatcity.com>

Based on the name I'm guessing this datafile is the not the only datafile in the USER tablespace.
If so, you can not delete a datafile, you must delete the entire tablespace. You can, however shrink the datafile down to almost nothing via ALTER DATABASE DATAFILE '/......./user02.dbf' resize 64K;

Hope this helps.

............................................................................
.................................

Rich Gesler
<>< Saved By Grace

Database Administrator				office: 336 878-7268
LifeStyle Furnishings International		fax   : 336 878-7038
............................................................................
.................................

More men fail through lack of purpose than lack of talent.

> -----Original Message-----
> From: Linda Hagedorn [SMTP: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).
Received on Wed Jun 21 2000 - 12:55:37 CDT