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: HELP: Drop tablespace with missing datafile

Re: HELP: Drop tablespace with missing datafile

From: Lando <MarkL_at_quebim.com>
Date: 1997/08/25
Message-ID: <34020FD9.90DBF974@quebim.com>#1/1

startup mount;
alter database datafile '/patch/dftodrop.dbf' offline drop; alter database open;
drop tablespace xyz including contents;

Gerard H. Pille wrote:

> Hello Qi,
>
> I believe there is an 'alter database' command allowing you to set the
>
> datafile or tablespace off line, after which you should be able to
> clean
> things up.
> --
> Kind reGards,
>
> Gerard
> (ghp_at_santens.be; ghp_at_skynet.be)
>
> Qi Zheng <zheng_at_alexandria.sdc.ucsb.edu> schreef in artikel
> <33FDC6B3.70895E9A_at_alexandria.sdc.ucsb.edu>...
> > I would like to know how to drop a tablespace which has its datafile
 

> > deleted. The full story is that I create a new table space with new
 a
> > new datafile. By mistake, I removed the datafile via OS command. Now
 

> > I could not drop the tablespace. The Oracle 7.3.3 server keep
 returning
> > error messages whenever I try to drop the tablespace. Is there
 anyway
> > to force the server to drop such tablespace?
> >
> > Thanks.
> >
> > Qi Zheng
> > zheng_at_alexandria.sdc.ucsb.edu
> >
Received on Mon Aug 25 1997 - 00:00:00 CDT

Original text of this message

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