Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> exp data from WE8ISO8859P1 and imp in UTF8

exp data from WE8ISO8859P1 and imp in UTF8

From: Hannes Schuhboeck <schuhb_at_gmx.at>
Date: 13 Aug 2002 04:43:03 -0700
Message-ID: <3091b698.0208130343.63b11895@posting.google.com>


Hi,
I have to export data from the following DB

 NLS_LANGUAGE             AMERICAN
 NLS_TERRITORY            AMERICA
 NLS_ISO_CURRENCY         AMERICA
 NLS_DATE_LANGUAGE        AMERICAN
 NLS_CHARACTERSET         WE8ISO8859P1
 NLS_NCHAR_CHARACTERSET   WE8ISO8859P1
to the following:
 NLS_LANGUAGE             AMERICAN
 NLS_TERRITORY            AMERICA
 NLS_ISO_CURRENCY         AMERICA
 NLS_DATE_LANGUAGE        AMERICAN
 NLS_CHARACTERSET         UTF8

 NLS_NCHAR_CHARACTERSET UTF8 1.) Source DB: export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1 2.) Source DB: exp ...

3.) Target DB: export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1 4.) Target DB: imp ...

Is this correct?
How can I check if the Characters are OK ?

Hannes Received on Tue Aug 13 2002 - 06:43:03 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US