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@]来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/85922/viewspace-922156/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
