源库A: WE8ISO8859P1
目标库B: ZHS16GBK
1,源库A上,表test字段value包含汉字,并对表test创建一个视图:
create or replace view v_isotogbk as select id,utl_raw.cast_to_raw(value) value from test;
注:判断是否含有中文
select value from test where asciistr(replace(value ,'\',' ')) like '%\%';
2,在目标库B上,创建一个dblink
create database link db228 connect to zhong identified by xxxx
using '(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 119.139.88.228)(PORT = 1521))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = pddb)))';
3,目标库B上,使用utl_raw.cast_to_varchar2函数创建其对应的视图
create or replace view v_isotogbk as select id, utl_raw.cast_to_varchar2(value) value from v_isotogbk@db228;
4,如不需要同步,查询上面视图即可,需要同步则可以使用物化视图,并定期刷新
create materialized
view mv
refresh complete on demand
as select id, value from v_isotogbk;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/23073818/viewspace-710965/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/23073818/viewspace-710965/