Re: imp

From: wangz <php_at_yeah.net>
Date: 3 Sep 2002 19:45:54 -0700
Message-ID: <6f77ff2a.0209031845.1419ddf9_at_posting.google.com>


check out this article:
NLS CONSIDERATIONS WHEN DOING EXPORT/IMPORT at: http://www.wangz.net/nls_ei.php
It may helpful to you!

Gudu Software
http://www.wangz.net

Marcelo Muzilli <marcelo_muzilli_at_hotmail.com> wrote in message news:<3D75105C.51FBED51_at_hotmail.com>...
> Hi Geoffrey,
>
> as you can see, this export file was transferred from another system (NT
> to UNIX) and they have different character set. Ensure it was handled as
> a BINARY file if FTP'd. This error (and others) can be sigalled if the
> file was not transferred properly.
>
> Regards,
>
> Marcelo Muzilli
>
> Geoffrey wrote:
> >
> > Hi,
> >
> > I'm getting the following errors when trying to import a dmp file :
> >
> > import done in US7ASCII character set and WE8ISO8859P1 NCHAR character set
> > import server uses WE8ISO8859P1 character set (possible charset conversion)
> > IMP-00069: Could not convert to environment national character set's handle
> > IMP-00021: operating system error - error code (dec 2, hex 0x2)
> >
> > Export lauched on : ORACLE 8.1.7.0.0 (NT)
> >
> > Import launched on : ORACLE 8.0.5.0.0 (Solaris)
> >
> > Can you help me ?
> >
> > Regards.
Received on Wed Sep 04 2002 - 04:45:54 CEST

Original text of this message