Re: Problem with Export/Import

pstryjew_at_att.net (pstryjew) wrote in message news:<29f8354.0305121842.25645de9_at_posting.google.com>...
> Hello all, I'm hoping for a little help.
>
> Export from Oracle 8.0.4
> Direct Path
> Buffer= 102400 (but shouldn't matter since direct path??)
>
> Try to import to 8.1.7
> But get:
> IMP-00051: Direct path exported dump file contains illegal column length
> IMP-00008: unrecognized statement in the export file:
> M-~M-^?^A
> ....and on and on.....
> Most have what appears to be ctrl-M, but file was ftp'ed in binary mode.
> IMP-00008: unrecognized statement in the export file:
> #^]^PM-~M-^?M-~M-^?M-~M-^?M-~M-^?M-~M-^?M-~M-^?M-~M-^?M-~M-^?M-~M-^?M-~
> M-^?M-~M-^?M-~M-^?M-~M-^?M-~M-^?M-~M-^?M-~M-^?M-~M-^?M-~M-^?M-~M-^?M-~M-^?M-~
> M-^?M-~M-^?M-~M-^?M-~M-^?M-~M-^?M-~M-^?M-~M-^?M-~M-^?M-~M-^?M-~M-^?M-~M-^?M-~
> M-^?M-~M-^?M-~M-^?M-~M-^?M-~M-^?M-~M-^?M-~M-^?M-~M-^?M-~M-^?M-~M-^?M-~M-^?M-~
> M-^?M-~M-^?M-~M-^?M-~M-^?M-~M-^?M-~M-^?M-~M-^?M-~M-^?M-~M-^?M-~M-^?M-~M-^?M-~
> M-^?^D
>
> Also have a character set difference:
> import done in US7ASCII character set and WE8ISO8859P1 NCHAR character set
> import server uses WE8ISO8859P1 character set (possible charset conversion)
> export server uses US7ASCII NCHAR character set (possible ncharset conversion)
>
> Any suggestions?
>
> Pete Stryjewski
> pstryjew_at_att.net

Hi Pete,

Regarding the IMP-00051 error, it might be worth trying the export via conventional path rather than direct path. It might well make no difference but worth a try I would say. The other possibility is to try setting the RECORDLENGTH parameter to an arbitrarily large value (say 64000).

Regards,

Tim Kearsley
Database Manager
Milton Keynes Council Received on Tue May 13 2003 - 02:49:37 CDT