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:35:24 CST