Re: HELP: change character set during export
Date: Fri, 27 Jul 2001 09:58:30 +0200
Message-ID: <3B611F26.22AF0AAF_at_rfn.de>
Ed Wong wrote:
> Hi, I need to know how to export database in WE8ISO885P1 character
> set. I am trying to export a database with WE8ISO8859P1 character
> into dump file and import it to another database.
>
> However, when I do the export, I got -
> Export file created by EXPORT:V08.01.06 via conventional path
> import done in US7ASCII character set and WE8ISO8859P1 NCHAR character
> set
> import server uses WE8ISO8859P1 character set (possible charset
> conversion)
> After I export/import, the data is corrupted.
>
> I tried setting 'setenv NLS_LANG WE8ISO8859P1' or 'setenv NLS_LANG
> AMERICAN_AMERICA.WE8ISO8859P1' both doesn't work and give me
> EXP-00056: ORACLE error 12705 encountered
> ORA-12705: invalid or unknown NLS parameter value specified
>
> Oracle 8.1.6 EE 64-bit, Solaris 2.7, export/import done on same
> server(oracle client 8.1.6).
Hello,
have checked my setenv's.
setenv ORA_NLS33 $ORACLE_HOME/ocommon/nls/admin/data
setenv LANG C.iso88591
setenv NLS_LANG american_america.WE8ISO8859P1
It's working fine with 8.1.7 EE 64 bit HP-UX 11i Received on Fri Jul 27 2001 - 09:58:30 CEST