In Oracle, you can NOT and should NEVER drop a datafile from a a tablespace. Oracle, however, provided a single SQL interface to doing so ONLY in anticipation to dropping the entire tablespace. You only choice is to follow what's mentioned in the other 2 replies. Even with 10gR2, the DATAFILE must be blank.
Thank you Fred Habash, Lead Oracle DBA (OCP 8i,9i) Oracle Team Portal http://spc-00sv0d03e3.spc.supc.com/ddcports/oracle/ _______________________________________________________________________________________ACS HealthCare Solutions Dearborn, MI | Off.: 248-226-8778 | fhabash@xxxxxxxxxxx | http://www.acs-hcs.com
-- //www.freelists.org/webpage/oracle-l