PROBLEM NATIONAL CHARACTER

Posted by Arsalan on Aug 21, 2017; 11:34am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/PROBLEM-NATIONAL-CHARACTER-tp3260.html


Hello Arsalan

The production server database.

1- windows 2003

2-Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE 11.2.0.3.0 Production
TNS for 64-bit Windows: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production
--------------------------------------------------------------------------------------------

DWH DATABASE

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

OS Windows 2008 R2 Enterprise

when i want to display or get data from production  database  into DWH DATABASE

It does not display the correct data in DWH  it show ###$$$###3,

Even if i write query like

select * from address@afgprod;

it does not show correct data of character

i used the blow script but still have problem

SHUTDOWN IMMEDIATE;
STARTUP MOUNT;
ALTER SYSTEM ENABLE RESTRICTED SESSION;
ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
ALTER SYSTEM SET AQ_TM_PROCESSES=0;
ALTER DATABASE OPEN;
ALTER DATABASE NATIONAL CHARACTER SET INTERNAL_USE AL16UTF16;
SHUTDOWN IMMEDIATE;
STARTUP;

not show pashto language character