Background:now I have two oracle 11gR2 database in different machines,one is a product database,the characterset is ZHS16GBK ;the other one is a new database,the characterset is AL32UTF8?either the system is oracle linux 5.8?
Question: now I create a dblink in the new database,use CTAS transmission data, neither the client NLS_LANG is ZHS16GBK or AL32UTF8 ,when I connect to the database ,select from the table ,the data is Garbled?
Can you give me some suggestions to resolve the garbled problem?
Thanks in Advance.
You can view more tutorials about SAP Oracle