Re: PROBLEM NATIONAL CHARACTER

Posted by Arsalan on Aug 22, 2017; 10:31am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/PROBLEM-NATIONAL-CHARACTER-tp3260p3301.html

1-The below character set of production database is

SQL> SELECT value$ FROM sys.props$ WHERE name = 'NLS_CHARACTERSET' ;

VALUE$
---------------------------------

AL32UTF8

2-The below character set of DWH Database.


SQL> SELECT value$ FROM sys.props$ WHERE name = 'NLS_CHARACTERSET' ;
VALUE$
---------------------------
WE8MSWIN1252

We create dblink from dwh database to production database.

mean we query data from production database in DWH Database.


Character set is different