title: ORA-01537. i want to search where the file is included, again
body: <p>i asked this question. but i can't solve. i want to ask again.</p>
  
  <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
   where UPPER(FILE_NAME) like '%JAVA.DBF';
  no rows selected.
  </code></pre>
  
  <p>i just want to know the statement searching where the file is included.
  my oracle is 11g.</p>