----------------------------------
Originally by- pipo
I do not agree, Pando is right here : you CANNOT drop a datafile w/o dropping the tablespace.
you can make the datafile offline, but it will still be on your HD, it won't be dropped !!
------------------------------------

Even if you drop the tablespace the datafiles will still be in your HD. The only way you can remove a file from HD is by OS command only...

Sandy