請(qǐng)問(wèn)：如何徹底刪除數(shù)據(jù)文件

anber45

alter database datafile '/oracle/oracle/oradata/ora920/system02.dbf'  OFFLINE drop;

刪除增加錯(cuò)誤的數(shù)據(jù)文件后，重啟數(shù)據(jù)庫(kù)后，用select FILE_NAME from dba_data_files;還是可以找到相應(yīng)的數(shù)據(jù)文件，
select file#,name,status from v$datafile;看到數(shù)據(jù)文件的狀態(tài)是RECOVER，請(qǐng)問(wèn)怎樣可以徹底的將datafile '/oracle/oracle/oradata/ora920/system02.dbf'在數(shù)據(jù)庫(kù)中刪除呢？

rollingpig

alter database datafile '...'
offline drop;

sailorxue

是這樣的，但執(zhí)行alter database datafile filename offline drop后應(yīng)在v$datafile內(nèi)狀態(tài)為offline，這也許是Oracle公司應(yīng)解決的問(wèn)題。

Once you make a datafile part of a tablespace, the datafile CANNOT be removed,  although we can use some workarounds.

If you have more than one datafile in the tablespace and you wish to keep the  objects that reside in the other datafile(s) which are part of this tablespace, then you must export all the objects  inside the affected tablespace.



廣東勵(lì)康  提供Oracle技術(shù)支持服務(wù)

godtears

不允許的，oracle的數(shù)據(jù)在數(shù)據(jù)文件間分配，刪除了一個(gè)數(shù)據(jù)文件后別的數(shù)據(jù)文件記錄的內(nèi)容也不完整了，如果要?jiǎng)h一個(gè)數(shù)據(jù)文件的話和刪了個(gè)表空間再重建差不多。

sshd

you should drop the entire tablespace instead of the individual datafiles.

drop tablespace xxx including contents and datafiles;
(warning: make sure know what you are doing)

"alter database datafile '/oracle/oracle/oradata/ora920/system02.dbf' OFFLINE drop;"
does not actually drop the datafile. it only marks it as offline.