查询DBA_TEMP_FILES报错，删除临时表空间报错ORA-60100

最新推荐文章于 2025-02-27 10:34:29 发布

潇湘秦（樊武振）

最新推荐文章于 2025-02-27 10:34:29 发布

阅读量633

点赞数 4

分类专栏： oracle 案例解决文章标签： dba 数据库 oracle

本文链接：https://blog.csdn.net/xiaofan23z/article/details/139959293

版权

SYMPTOMS

查询DBA_TEMP_FILES报错如下图

ORA-01157: cannotidentify/ock data fle 201 -see DBWR trace fle
ORA-01110: data fle 20 1: 'D:APPADMINISTRATORIORADATA MARTIDATAFILE'
01157,00000-"cannotidentify/ock data fle %s -see DBWR trace fle"*Cause: The background process was either unable to find one of the datafles or failed to lock it because the fle was already in use.The database will prohibit access to this fle but other fles will!
be unaffected, However the frst instance to open the database willneed to access all online data fles, Accompanying error fom theoperating system describes why the fle could not be identifed.Action: Have operating system make fle available to database. Then eitheropen the database or dO ALTER SYSTEM CHECK DATAFILES.