- 论坛徽章:
- 0
|
alter database datafile 'dev\oracle\qqfw.dbf' offline drop;提示成功删除数据文件
用这个SQL从表空间删除数据文件,从而达到释放出该文件给其他表空间用的概念是错误的。
NOTE: The ALTER DATABASE DATAFILE <datafile name> OFFLINE DROP command, is not meant to allow you to remove a datafile. What the command really means is that you are offlining the datafile with the intention of dropping the tablespace.
If you are running in archivelog mode, you can also use: ALTER DATABASE DATAFILE <datafile name> OFFLINE; instead of OFFLINE DROP. Once the datafile is offline, Oracle no longer attempts to access it, but it is still considered part of that tablespace. This datafile is marked only as offline in the controlfile and there is no SCN comparison done between the controlfile and the datafile during startup (This also allows you to startup a database with a non-critical datafile missing). The entry for that datafile is not deleted from the controlfile to give us the opportunity to recover that datafile.
如果想另外的表空间利用这个raw device,只有将拥有这个raw device文件的表空间drop,重新创建该表空间,然后再另外的表空间上add datafile |
|