删除具有实例化视图和丢失数据文件的表空间
|
我有一个部分恢复的数据库（出于测试目的），由于它们的大小和性质，缺少了几个表空间。因此，我需要删除这些表空间，但是其中一些表空间已在其中实现了物化视图，这使我陷入了困境。
> drop tablespace test including contents and datafiles;
drop tablespace test including contents and datafiles
*
ERROR at line 1:
ORA-23515: materialized views and/or their indices exist in the tablespace
drop materialized view test.test_table_mv;
drop materialized view test.test_table_mv
*
ERROR at line 1:
ORA-00376: file 172 cannot be read at this time
ORA-01111: name for data file 172 is unknown - rename to correct file
ORA-01110: data file 172: \'/u01/software/9.2.0.5.0/dbs/MISSING00172\'
没有找到相关结果
已邀请:
1 个回复
奥李