Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Delete a datafile without droping tablespace

Re: Delete a datafile without droping tablespace

From: Michael Ho <infoage_at_hk.super.net>
Date: 1997/04/07
Message-ID: <3347C967.4D36@hk.super.net>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US