Re: Delete a datafile without droping tablespace

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.

• Jeff

  ---

  ,-~~-.___. Jeffrey Hunter / | ' \ Computer Scientist/Math Programmer ( ) 0 * * * \_/-, ,----' Lawrence Livermore National Laboratory
  • // P.O. Box 808, L-435 Livermore, CA 94551 / \-'~; /~~~(O) * * * / __/~| / | EMAIL: jhunter_at_llnl.gov =( _____| (_________| PHONE: (510) 423-0271

    ---