pando
quote:
---------------------------------------------------------------------
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
-----------------------------------------------
Don’t be so stubborn

what will happen if my TS has more then one datafile...if the command will force me to drop entire tablespace...??
As I told earlier, when you offline drop the datafile oracle will never ask you for recovery of this datafile at the time of next startup...even if you drop this file physically from HD... what does this mean...
Logically I have dropped my datafile.
think about it...

Sandy