Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> imp can't read my export file, what does this error mean?

imp can't read my export file, what does this error mean?

From: Stan Brown <stanb_at_panix.com>
Date: Wed, 1 Oct 2003 15:50:04 +0000 (UTC)
Message-ID: <blet3c$jq9$1@reader2.panix.com>


For those of you following my ongoing (now approaching a week long) saga. Here is the latest.

I've got the Oracle instance backup, recreated the datafiles/tablespaces that I had to drop. The recreated the indexes, and objects that were in those datafiles.

Now the only remaining thing to di is recover a small bit of data from the previous nights dump file. Getting access to that file was a fairly long excersise, as it's about 10G in size! I do not have that much spare disk space on the Oracle machine, so I ungiziped it on a handy FreeBSD machine. Then I had to patch the Oracle machine (HP-UX) to enable NFS V3, so that I could correctly access this file over NFS. At this point, I thought I was home free. Far from it :-( Now Oracle is giving me fits again. When I try to run imp to import the tables I need, I get:

Connected to: Oracle7 Server Release 7.3.4.5.0 - Production PL/SQL Release 2.3.4.5.0 - Production

Import file: expdat.dmp > oracle_dump.09242003.exp

IMP-00002: failed to open oracle_dump.09242003.exp for read IMP-00021: operating system error - error code (dec 2, hex 0x2)

What the heck is this trying to tell me?

Is this file too big of imp?

Is thee a way around this?

-- 
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
						-- Benjamin Franklin
Received on Wed Oct 01 2003 - 10:50:04 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US