Hello,

If you have table that you want to drop it in a tablespace then you can drop tablespace including contents and datafiles

-----Message d'origine-----
De : Menaka [mailto:oracledba-ezmlmshield-x92900615.[Email address protected]
Envoyé : mercredi 30 avril 2008 08:26
À : LazyDBA Discussion
Objet : delete datafile

Hai experts
Some one delete my datafile. Some tables are pointing that datafile. Now i am not able to drop the tables that pointing that deleted datafile. I want to drop that tables. Is their any way to delete it?

Thanks
Menaka.R


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page