Re: cannot delete datafile after droping tablespace for Oracle9i

cnwy_at_263.net wrote:
> Hello
>
> I have run the SQL "drop tablespace undotbs2 including contents and
> datafiles" sucessfully, but I can find this file in OS folder still
> ,why? Furthermore, when I delete this file in OS folder by manual, it
> shows error message "the file is using, cannot be deleted". Who can
> give me any suggestions? Thanks!
>
> B&R
> wy

DROP TABLESPACE <tablespace_name> INCLUDING CONTENTS AND DATAFILES;

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)