You can
> ALTER TABLESPACE ts_name OFFLINE;
After that, I think, dropping the ts should work.

Anat :o)

----- Original Message -----
From: "Abdul Wahab Ansari "
<oracledba-ezmlmshield-x64371139.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Sunday, April 02, 2006 3:31 PM
Subject: datafile dropped


> Hello
> One programmer misused his rights and dropped a datafile without
> dropping the tablespace. How can we drop the tablespace
> Now?
>
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>
>
>


Oracle LazyDBA home page