ACSDBA
asked on
Having an issue with temp datafile
SQL> select * from dba_temp_files;
ERROR:
ORA-01157: cannot identify/lock data file 202 - see DBWR trace file
ORA-01110: data file 202: 'F:\ORACLE\ORADATA\IWDBT\T EMP01.DBF'
I just ran this query against my database. The path f:\oracle\oradata\iwdbt\ doesn't exist in my environment. How can I get this fixed? The correct path is f:\oracle\oradata\iwdb
ERROR:
ORA-01157: cannot identify/lock data file 202 - see DBWR trace file
ORA-01110: data file 202: 'F:\ORACLE\ORADATA\IWDBT\T
I just ran this query against my database. The path f:\oracle\oradata\iwdbt\ doesn't exist in my environment. How can I get this fixed? The correct path is f:\oracle\oradata\iwdb
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
1). Create another temporary tablespace
2). Make this newly created tablespace as default temporary tablespace
3). drop the old temporary tablespace including temp files.