after droping the datafile . i believe we cannot make it online
with a similar syntax . only option it leaves is to recover the database if it is in archivelog mode .
is this syntax valid prior to version 8 .
Originally posted by soniaarora Pando, what do u mean by 'force to drop entire tablespace'? I agree that offline a datafile means that u may drop the tablespace at a later time and not that U will be forced to drop it.
no, you are forced to, you cant never ever remove a datafile from a tablespace