Re: Delete a datafile without droping tablespace

Jeffrey M Hunter wrote:

> Oracle Developer wrote:
> >
> > I need to delete a datafile from a tablespace but I can not drop
 the
> > tablespace to do so. I do not have the time to do an export.
> > The datafile has no data blocks being used.
> >
> > Can some please help.
> >
> > robert.hill_at_usld.com
>
> I was in this same situation. I could not find ANY way to
> drop the datafile without first exporting the data, dropping
> the tablespace then creating it with that one less datafile.
>
> I do know that in Oracle 7.3 and greater that there is a
> RESIZE option for altering the size of datafiles. Might try that
> if you are simply looking for the space.

 Hmm, don't know if it will work, but try this command at the svrmgr prompt after connecting internal:

alter database drop tablespace '/name of datafile' offline drop;

(I would HIGHLY recommend looking at the ramifications of this command before doing so... Dropping a file from oracle is like pulling your own teeth. It can be done, but .... ) Received on Sun Apr 20 1997 - 00:00:00 CDT