ORA-01537.我想搜索文件所在的位置 [英] ORA-01537. i want to search where the file is included

问题描述

SQL> alter tablespace java add datafile 'd:/programming/java.dbf';
*
ERROR at line 1:
ORA-01537: cannot add file 'd:/programming/java.dbf' - file already part of database


SQL> select TABLESPACE_NAME,FILE_NAME,STATUS from dba_data_files
2  where FILE_NAME='%JAVA.DBF';
no rows selected.

我只想知道搜索文件所在位置的语句.

i just want to know the statement searching where the file is included.

推荐答案

使用like代替=:

select TABLESPACE_NAME, FILE_NAME,STATUS 
from dba_data_files
where UPPER(FILE_NAME) like '%JAVA.DBF';

这篇关于ORA-01537.我想搜索文件所在的位置的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！