删除dbf数据文件的问题

yyiiasc

不小心用rm命令直接删除了刚加到tablespace A中的DBF文件b
b中无数据
目前tablespace不正常，请问怎么解决
谢谢

fish617

alter database datafile '...../b.dbf' offline drop;
试一下！！

icewood

目前table space状态怎么样？

yyiiasc

现在没办法通过控制器看状态了，报错
用语句怎么看呀

sshd

if you do not want to keep the data in the tablespace,

drop tablespace xxx including contents and datafiles;

loufangxin

原帖由 "sshd" 发表：
if you do not want to keep the data in the tablespace,

drop tablespace xxx including contents and datafiles;

alter database datafile missingfilename offline drop;
alter database open;
create a new tablespace;
move ts_a object to ts_new;
drop tablespace a;

yyiiasc

谢谢大家回复
试过alter database datafile '...../b.dbf' offline drop;
目前tablespace状态已正常，只是会记录DBF b 需要恢复
我想保留tablespace但想根本性的删掉b dbf文件请问怎么做

loufangxin

原帖由 "yyiiasc" 发表：
谢谢大家回复
试过alter database datafile '...../b.dbf' offline drop;
目前tablespace状态已正常，只是会记录DBF b 需要恢复
我想保留tablespace但想根本性的删掉b dbf文件请问怎么做

Up, see my message.

sshd

yes, that file needs recovery. it's possible only if you have proper backup.

if there is no backup (most likely that's your case), drop the tablespace is the only option.