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

Can I delete a datafile not used?

From: Alberto Rivera <usfmd2ya_at_ibmmail.com>
Date: 1996/10/16
Message-ID: <542jbo$8fv@eccdb1.pms.ford.com>#1/1

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 16 1996 - 00:00:00 CDT

Original text of this message

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