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: '
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. ?