DROP TABLESPACE does not remove the .ora file

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Tue, 7 Jan 2003 13:42:40 -0000
Message-ID: <E2F6A70FE45242488C865C3BC1245DA70321B4A1@lnewton.leeds.lfs.co.uk>

Gijo,

I'm afraid you need to wait until 9i to be able to drop the data files as well using (if I remember correctly) :

DROP TABLESPACE XXXX INCLUDING CONTENTS AND DATAFILES [CASCADE CONSTRAINTS]; Cheers,
Norman.

---

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com
-------------------------------------

-----Original Message-----
From: gijovarghese_at_yahoo.com (Gijo Varghese)
[mailto:gijovarghese_at_yahoo.com]

Posted At: Tuesday, January 07, 2003 1:35 PM Posted To: server
Conversation: DROP TABLESPACE does not remove the .ora file Subject: DROP TABLESPACE does not remove the .ora file

[Oracle 8i Solaris.]

I have created a tablespace WpTest.ora

Now I am using the command

DROP TABLESPACE WpTest.ora INCLUDING CONTENTS CASCADE CONSTRAINTS;

I am getting Tablespace dropped message.

But I can still see the file WpTest.ora.

Why is it so? Is it that the .ora file is not removed by Drop Tablespace command?

if not, is there any command available to remove the .ora file too?

[rather than manually deleting the .ora file]

Thanks ,
Gijo Received on Tue Jan 07 2003 - 07:42:40 CST