解决不同字符集数据库间的数据同步问题

10.0.10.108:testdb zhs16gbk
10.10.10.166:gsweb us7ascii

CREATE VIEW V_CITY AS SELECT UTL_RAW.CAST_TO_RAW(NAME) AS NAME FROM CITY;
SELECT * FROM V_CITY;

SQL> 
create public database link testdb connect to itax 
identified by itax using 'testdb';

Database link created.

select utl_raw.cast_to_varchar2(name) from V_city@testdb

CREATE VIEW V_fg_wh AS SELECT UTL_RAW.CAST_TO_RAW(fg_wh) AS fgwh FROM fg_wh;

create public database link gsweb connect to gs12366 
identified by htjs_12366 using 'gsweb';

create view fg_wh as 
select utl_raw.cast_to_varchar2(fgwh) fgwh from v_fg_wh@gsweb