Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Can I delete a datafile not used?
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