SQL>  select FILE_NAME,TABLESPACE_NAME from dba_temp_files;

ERROR at line 1: ORA-01157: cannot identify/lock data file 201 - see DBWR trace file ORA-01110: data file 201: '/oradata_nocg/temp01.dbf'

In the database I don't have '/oradata_nocg/temp01.dbf', I am not doing any operation related temp tablespace Why it is not allowing run above select query. ?

  • First you check your temp file is exist on specific location or not. from this query SQL>select file#,status,name from v$tempfile; and SQL> select * from v$tempfile; – Md Haidar Ali Khan Sep 10 '15 at 5:28

Your Answer


By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Browse other questions tagged or ask your own question.