Re: DROP TABLESPACE does not remove the .ora file

Gijo,

The drop tablespace command does not remove the underlying files. It is easy enough to generate a script to clean up after the tablespace drop by querying the dba_data_files view a UNIX version might look like this:

spool run_me_after_drop.sh
select 'rm '||file_name from dba_data_files where tablespace_name = 'tablespace to be dropped';
spool off

If you are using NT or W2K just substitute del for rm.

Kind Regards,

Fraser McCallum
MVP Oracle Administration
www.brainbench.com

"Gijo Varghese" <gijovarghese_at_yahoo.com> wrote in message news:f94477e9.0301070535.704a8f2d_at_posting.google.com...
> [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 Wed Jan 08 2003 - 16:11:37 CST