CODEWITHSUNDEEP
oracle-databaseimport
user2753228
user2753228

Reputation: 1

Error during import in oracle 10g

Need Solution for the below error. I have dump file to restore in a database. But got a error during import. 

IMP-00002: failed to open C:\oracle\product\10.2.0\NEFT_IFSC.dmp for read
Import file: EXPDAT.DMP >

Upvotes: 0

Views: 460

Answers (1)

APC
APC

Reputation: 146349

There are lots of things it could be: file path is wrong, file is corrupt, file is too big, permissions on the directory, file name is wrong, and so on.

You may find it helpful to run your import using a parameter file. Not only will that save you some typing if you end up re-running this several times, it will give you the possibility to review what you're about to submit. Find out more.

Also you can set the SHOW=Y parameter to validate the contents of the file.

Upvotes: 1

Related Questions