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.

may?

no, you are forced to, you cant never ever remove a datafile from a tablespace