Dropping datafiles

Hi,
How do I drop the datafiles?
Please let me know.

You should not be dropping the datafile. The correct way is to drop the tablespace and then remove the datafiles from the OS.

Check this thread --

http://dbasupport.com/forums/showthr...?threadid=6697


- Rajeev

First...bring the tablespace offline...
Alter tablespace tablespace_name offline;
check the status of the tablespace....
drop tablespace tablespace_name...
and at os level...
rm datafile name.
it will work.
good luck.
Thanigaivasan