Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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.
I don't have reference handy, I remember you can ALTER TABLESPACE DROP DATAFILE. Received on Mon Apr 07 1997 - 00:00:00 CDT