alter database datafile .... offline drop的問題

10G 之前:

If the database is in NOARCHIVELOG mode, you must specify the DROP clause to take a datafile offline. However, the DROP clause does not remove the datafile from the database. To do that, you must drop the tablespace in which the datafile resides. Until you do so, the datafile remains in the data dictionary with the status RECOVER or OFFLINE.

If the database is in ARCHIVELOG mode, Oracle ignores the DROP keyword.

10G 之後:

ALTER TABLESPACE ... DROP DATAFILE ...;

[@more@]