Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Drop datafile
Daniel,
I remember tried this before and end up using drop tablespace (using "drop tablespace xxx including contents") and then manually remove data files. If you can't drop tablespace, you might want to do a "resize" to shrink the data files.
Let me know if there is a better solution.
David
On Fri, 02 Jan 1998 18:47:31 +0100, Daniel Pinol <dpinol_at_cesca.es> wrote:
>Hi,
> is it possible to drop a non-used datafile from a tablespace?
>I tried with alter database offline drop, but the file is still in
>dba_data_files. If I remove the physical file, Oracle complains.
>
> Thanks
> I'll appreciate an email to dani_at_cesca.es
Received on Sun Jan 04 1998 - 00:00:00 CST