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: Can I delete a datafile not used?

Re: Can I delete a datafile not used?

From: suvas <suvas_at_pacific.net.sg>
Date: 1996/10/30
Message-ID: <01bbc6e7$30822080$9b5178cb@Singnet.singnet.com.sg>#1/1

Startup the database and mount the datafiles and give the following command in SQLDBA.
SQLDBA>ALTER DATABASE DATAFILE '<datafile name>' OFFLINE DROP;

Alberto Rivera <usfmd2ya_at_ibmmail.com> wrote in article <542jbo$8fv_at_eccdb1.pms.ford.com>...
> I make a mistake and add a datafile to a wrong
> tablespace.
>
> The datafile is not used by any segment because
> the tablespace already had enough free space with
> another datafiles.
>
> So I want to delete such datafile or assign it
> to the right tablespace. It's possible?
>
> Oracle7 v7.2.3 on AIX 4.1
>
> Thanks in advance.
>
>
>
  Received on Wed Oct 30 1996 - 00:00:00 CST

Original text of this message

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