您好,登錄后才能下訂單哦!
近期開始做OGG的項(xiàng)目,測(cè)試過(guò)程中遇到一個(gè)問題。使用CTAS創(chuàng)建一張表,表中有數(shù)據(jù),然后使用delete from xxx;刪除表之后,replicat進(jìn)程異常。查看ogg日志,查看官網(wǎng)找到原因。
官方文檔號(hào)
How to Capture the DML(s) Executed by a DDL Trigger (OGG) (文檔 ID 1509900.1)
解決方案
SOLUTION
By design, Extract (Classic/ Integrated) doesn't capture the dmls from a DDL transaction (eg, inserts as a result of CTAS) or the dmls from a DDL trigger regardless of whether DDL replication is enabled or not. This is working correctly as per the design and not a bug
測(cè)試過(guò)程:
connect cytdas/cytdas
create table oggtest as select * from dba_users;
查看ogg進(jìn)程正常,數(shù)據(jù)同步正常
delete from oggtest;
目的端發(fā)現(xiàn)replicat進(jìn)程abend,查看日志發(fā)現(xiàn)ORA-01403錯(cuò)誤哦。
這里不是BUG,不是BUG,是OGG的設(shè)計(jì)要求,我們只要工作中注意就好了。
可是把這個(gè)表排除掉繼續(xù)測(cè)試。
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng),如果涉及侵權(quán)請(qǐng)聯(lián)系站長(zhǎng)郵箱:is@yisu.com進(jìn)行舉報(bào),并提供相關(guān)證據(jù),一經(jīng)查實(shí),將立刻刪除涉嫌侵權(quán)內(nèi)容。