Re: HELP: change character set during export

ewong_at_mail.com (Ed Wong) wrote in message news:<a5ae1554.0107261750.572d0c5_at_posting.google.com>...
> 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).

Which characterset are you trying to convert *from*. Both charactersets need to be a super/subset of each other. Also you can verify in the database which charactersets are available to you by querying v$nls_valid_values.
If you'd installed the database in plain English the only characterset available is US7ASCII!

Hth,

Sybrand Bakker, Senior Oracle DBA Received on Fri Jul 27 2001 - 09:42:57 CEST