Re: IMP-00020 info
- From: "Ron Rogers" <RROGERS@xxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 11 May 2004 14:39:36 -0400
Joe,
I'm glad that you were able to isolate the problem with the exp/imp. I
tried the DIRECT,RECORDLENGTH, and others suggested by OWS in the
metelink search results. I still don't think they know what causes the
problem because there is no ONE answer to the problem.
The import is into an Oracle 9.2.0.5 database. Maybe that is the
problem? I first discovered the problem when the export size was over 60
meg.
Thanks for the brew,
Ron
>>> aregularjoe8@xxxxxxxxx 05/11/2004 1:47:26 PM >>>
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
Ron Rogers <RROGERS@xxxxxxxxxxxxx> wrote:
Joe,
I got the FTP to work properly by adding the BINARY option in the
here-file that I used to get the dmp files from the OpenVMS server. I
am
using WS-FTP to ftp the files from the server to the pc and WS-FTP to
push the files to the Linux box. The option for WS-FTP are set to use
BINARY for all transfers.
It appears that the default transfer for ftp on linux is not binary.
Ron
---------------------------------
Do you Yahoo!?
Win a $20,000 Career Makeover at Yahoo! HotJobs
----------------------------------------------------------------
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
-----------------------------------------------------------------
----------------------------------------------------------------
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:
