Originally posted by prakashs43
i support pando . we cannot ever drop a datafile . if u drop it u need to drop the tablespace as well . else u need a recovery to be performed .

OFFLINE takes the datafile offline. If the database is open, you must perform
media recovery on the datafile before bringing it back online, because
a checkpoint is not performed on the datafile before it is taken offline.
DROP takes a datafile offline when the database is in
NOARCHIVELOG mode.

Hope this makes u clear .

after Offline drop[ing] a datafile Oracle will never ask you for recovery at the time of next startup even the datafile is been removed physically from the HD. I would never like to bring the datafile online as I've dropped it only because I don't want it any more.
How can you say U need to drop the TS as well. Plz let me know the case where I have more then one datafile in my TS. Try to do this in your experiment DB and you'll understand...