高级复制解决冲突用DBMS_RECTIFIER_DIFF.RECTIFY出现的问题
高级复制中可能存在数据冲突和不一致现象
BEGIN DBMS_RECTIFIER_DIFF.RECTIFY(
SNAME1 =>'JR01',
ONAME1 =>'TB_COM201',
REFERENCE_SITE =>'XH1.COM',
SNAME2 =>'JR02',
ONAME2 =>'TB_COM201',
COMPARISON_SITE =>'XH2.COM',
COLUMN_LIST =>'f1,f2,f3,f4...',
MISSING_ROWS_SNAME =>'JR02',
MISSING_ROWS_ONAME1 =>'TB_COM201_TMP',
MISSING_ROWS_ONAME2 =>'MISSING_LOCATION_COM201',
MISSING_ROWS_SITE =>'XH2.COM',
COMMIT_ROWS =>100
);
END;
ORA-22992: cannot use LOB locators selected from remote tables
ORA-06512: at "SYS.DBMS_RECTIFIER_DIFF", line 1876
ORA-06512: at "SYS.DBMS_RECTIFIER_DIFF", line 1663
ORA-06512: at line 1
出错的原因：'TB_COM201'包含clob字段， COLUMN_LIST中没包含改字段
[ 本帖最后由 microsoft_fly 于 2009-11-12 15:40 编辑 ]
BEGIN DBMS_RECTIFIER_DIFF.RECTIFY(
SNAME1 =>'JR01',
ONAME1 =>'TB_COM201',
REFERENCE_SITE =>'XH1.COM',
SNAME2 =>'JR02',
ONAME2 =>'TB_COM201',
COMPARISON_SITE =>'XH2.COM',
COLUMN_LIST =>'f1,f2,f3,f4...',
MISSING_ROWS_SNAME =>'JR02',
MISSING_ROWS_ONAME1 =>'TB_COM201_TMP',
MISSING_ROWS_ONAME2 =>'MISSING_LOCATION_COM201',
MISSING_ROWS_SITE =>'XH2.COM',
COMMIT_ROWS =>100
);
END;
ORA-22992: cannot use LOB locators selected from remote tables
ORA-06512: at "SYS.DBMS_RECTIFIER_DIFF", line 1876
ORA-06512: at "SYS.DBMS_RECTIFIER_DIFF", line 1663
ORA-06512: at line 1
出错的原因：'TB_COM201'包含clob字段， COLUMN_LIST中没包含改字段
[ 本帖最后由 microsoft_fly 于 2009-11-12 15:40 编辑 ]
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/751051/viewspace-731744/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
