CODEWITHSUNDEEP
oracle-database
Nidheesh
Nidheesh

Reputation: 4562

java.sql.SQLException: ORA-01157: cannot identify/lock data file

I was getting the below given error, When I run the application:

Caused by: org.hibernate.exception.GenericJDBCException: could not execute native bulk manipulation query
.
.
Caused by: java.sql.SQLException: ORA-01157: cannot identify/lock data file - see DBWR trace file
ORA-01110: data file : '/fld1/fld2/mytemp_tablespace.dbf'

I tried to find out this files and came to know that there is no folders. I have , then created the respective folders and a new empty mytemptemp_tablespace.dbf file. But still the same error is getting over there.

Any idea why this error is happening?If it is an SQL exception it could have happened at the right beginning itself. What I have done is, I have created a new schema and exported the db from the old to this new one.

Also how can I see or get the DBWR trace file.

Upvotes: 1

Views: 3435

Answers (1)

user123664
user123664

Reputation:

This could be the result of a restored database and during the restore rman was not able to create the tempfiles because of a missing directory. Solution is quite simple, once the directories are created, just add one or more tempfiles:

alter tablespace mytemp_tablespace add tempfile '/fld1/fld2/mytemp_tablespace01.dbf';

when the temp tablespace has it's storage, your actions can succeed.

Upvotes: 1

Related Questions