You can use the command "drop tablespace junk including contents and datafiles;". IIRC it was introduced in 9i. If you want to use the datafiles clause, you must use the including contents clause. ryan.gaffuri@xxxxxxx wrote: > i didnt notice that you can delete the datafile from with in oracle. I missed > it in the docs. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------