HELP: change character set during export
Date: 26 Jul 2001 18:50:42 -0700
Message-ID: <a5ae1554.0107261750.572d0c5_at_posting.google.com>
[Quoted] [Quoted] 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). Received on Fri Jul 27 2001 - 03:50:42 CEST