OS Drop data file

[rshivagami]

I am on Solaris where I need to drop a tablespace. I issued the 'DROP TABLESPACE ... INCLUDING CONTENTS' - now what is the OS command to drop the datafile - just 'rm filename' will do ? Are there additional precautions that I need to follow ?

Thanks.

[davey23uk]

yes, use rm, but if you are using 9i, use including contents and datafiles; and oracle will do it for you

[rshivagami]

Yes, I am using 9i - will make it a point to use 'DROP TABLESPACE ..AND DATAFILES' next time. But for now, will just an 'rm' suffice ?

[Axr2]

Yes, an "rm" will suffice after having issued the "drop tablespace ### inclduing contents"