Cannot identify/lock data file XXX ORA-01157, ORA-01110

User Rating: 5 / 5

Star ActiveStar ActiveStar ActiveStar ActiveStar Active
 

 

SQL> 
COL FILE# FORMAT 999;
COL NAME FORMAT A40;
SELECT FILE#, NAME FROM V$TEMPFILE;

ORA-01157: cannot identify/lock data file 201 - see DBWR trace file
ORA-01110: data file 201: 'C:\APP\ORADATA\IMKP\IMKP\TEMP01.DBF'

Cause: May by after restore database on the new host

 

Solution:

1. Check if the folder exists and permissions on it

2. Create folder then restart database. Temple will create automatically

 

To set new location of the temp file(-s) use Go to ORACLE DBA / General / File Management / Tempfiles

Newsletter

Enter your email to join our mailing list

Quick Contact