-
OS Drop data file
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.
-
yes, use rm, but if you are using 9i, use including contents and datafiles; and oracle will do it for you
-
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 ?
-
Yes, an "rm" will suffice after having issued the "drop tablespace ### inclduing contents"