RE: IMP-00020 info
- From: "Powell, Mark D" <mark.powell@xxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 11 May 2004 13:58:02 -0400
Joe, I hope you updated Support with the fact that the problem vanishes when
a conventional export is substituted for the direct export. This may save
someone some future grief.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Joe Cooper
Sent: Tuesday, May 11, 2004 1:47 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: IMP-00020 info
Ron,
Unfortunately, my IMP-00020 problem didn't turn out to be an ftp issue at
all. (It ALSO didn't turn out to be a corrupted file, as suggested by
Oracle Tech Spt.) By virtue of an educated (read 'lucky') guess, I decided
to try the export with direct=n instead of direct=y. That fixed it,
regardless of transfer method -- I tested rcp, unix-to-unix ftp, and ftp
with my Win2K desktop as an intermediary. My only quandry now is whether I
can afford a slower direct=n export for the sake of just one table, or do I
isolate the table into its own export. (The time window for this nightly
process isn't very generous!!) I guess I've got more testing to do!!
By the way, even though your solution didn't directly solve my problem, it
did prompt me to look at the problem in a different light. Therefore,
consider yourself the recipient of one virtual beer. And, should the
fickled finger of fate lead you to Austin, TX, look me up, and we'll convert
that virtual beer into a real one.
Take care!
Joe Cooper
Oracle DBA
Thomson Media (until the sale of our division FINALLY goes through, which
should be "any day now")
Austin, TX
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
