Quote:
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 .