Re: HELP: Drop tablespace with missing datafile

From: Gerard H. Pille <ghp_at_skynet.be>
Date: 1997/08/24
Message-ID: <01bcb0cf$828f9ce0$e51beec3@pcghp>#1/1

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 Sun Aug 24 1997 - 00:00:00 CDT