title: ORA-01537. i want to search where the file is included
body: <pre><code>SQL&gt; 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&gt; select TABLESPACE_NAME,FILE_NAME,STATUS from dba_data_files
  2  where FILE_NAME='%JAVA.DBF';
  no rows selected.
  </code></pre>
  
  <p>i just want to know the statement searching where the file is included.</p>