| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: IMP-00020 info
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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Joe Cooper
Sent: Tuesday, May 11, 2004 1:47 PM
To: oracle-l_at_freelists.org
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
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlReceived on Tue May 11 2004 - 12:56:21 CDT
-----------------------------------------------------------------
 |
 |