OFFLINE Specify OFFLINE to take the data file offline. If the database is open, then you must perform. media recovery on the data file before bringing it back online, because a checkpoint is not performed on the data file before it is taken offline.
FOR DROP If the database is in NOARCHIVELOG mode, then you must specify FOR DROP
clause to take a data file offline. However, this clause does not
remove the data file from the database. To do that, you must use an
operating system command or drop the tablespace in which the data file
resides. Until you do so, the data file remains in the data dictionary
with the status RECOVER or OFFLINE.
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29121762/viewspace-775044/，如需转载，请注明出处，否则将追究法律责任。