A system problem with orcale database Import on HP8UX machine

[MALKI]

When I tru to do an oracle database import with imp command I receive thos error message:IMP-00002: failed to open /opspdata2/dump_opsp_Sat.dmp for read
IMP-00021: operating system error - error code (dec 2, hex 0x2)
Can someone help me it's very important

[Sridhar Bhaskarla]

errno 2 correspond to No such file or directory. Did you check the permissions over /opspdata2/dump_opsp_Sat.dmp to see if you have read permissions for oracle?.

-Sri

[linuxfan]

Hi Malki,


Oracle error IMP-00002 says - "Failed to open %s for read"

Make sure the dump file /opspdata2/dump_opsp_Sat.dmp is readable by oracle. Check the permissions

-Ramesh

[Thierry Poels_1]

hi,

I agree with the 2 previous answers. You (oracle?) probable has no read permissions on the export file.

sorry for the late answer: could not access ITRC in the morning, and could not reply in the afternoon (troubles with the Europe server???) :((

regards,
Thierry.

[Brian Crabtree]

Something else to consider is that versions of imp for HP-UX cannot read files over 2g in size. If the file is over this size, you might want to consider piping the information into the import command:

mkdir -p imp_pipe
cat expdat.dmp > imp_pipe &
imp file=imp_pipe