óÏÒÒÉ, ÎÏ ÎÁÞÎÕ ÎÏ×ÙÊ ÐÏÓÔ, ïå ÚÁÇÌÀÞÉÌ.
ÏÄÉÎ ×ÏÐÒÏÓ Õ ÍÅÎÑ × ÇÏÌÏ×Å ÎÅ ÕËÌÁÄÙ×ÁÅÔÓÑ: ÅÓÔØ ÔÁÂÌÉÃÁ CHANGES, × ËÏÔÏÒÏÊ
ÄÌÑ ÒÅÐÌÉËÁÃÉÉ ÚÁÐÉÓÙ×ÁÀÔÓÑ × ËÁËÏÊ ÓÔÒÏÞËÅ ÞÔÏ ÉÚÍÅÎÉÌÏÓØ ÔÒÉÇÇÅÒÏÍ:
CREATE TRIGGER DOCUMENTS_REPL2 FOR DOCUMENTS
AFTER UPDATE AS
BEGIN
IF( USER <> 'REPL2' ) THEN
BEGIN
INSERT INTO CHANGES2(TABLEKEY,TABLENAME,OP,LOC_ID)
SELECT ÂÌÁ-ÂÌÁ-ÂÌÁ
FROM REPL_TABLES2 WHERE TABLENAME=DOCUMENTS;
END
END
ËÏÎÅËÔÉÍÓÑ Ë ÂÁÚÅ ÞÅÒÅÚ sysdba, ÁÐÄÅÊÔÉÍ DOCUMENTS, ÄÁÎÎÙÅ ÏÂ ÜÔÏÍ ÐÏÐÁÄÁÀÔ
× changes, ÎÁ ÜÔÏÍ ÜÔÁÐÅ ×ÓÅ ÏË.
òÅÐÌÉÃÉÒÕÅÍ ÄÁÎÎÙÅ: ËÏÎÎÅËÔÉÍÓÑ ËÁË REPL2 É × DOCUMENTS ÄÅÌÁÅÍ ÉÚÍÅÎÅÎÉÑ.
óÏÏÔ×ÅÔÓÔ×ÅÎÎÏ × ÔÒÉÇÇÅÒ ÏÎÉ ÎÅ ÐÏÐÁÄÁÀÔ.
ôÅÐÅÒØ ÔÏ, ÞÔÏ Õ ÍÅÎÑ ÎÅ ÕËÌÁÄÙ×ÁÅÔÓÑ × ÇÏÌÏ×Å: ëáë äïâá÷éôø ÷ üôõ óèåíõ
ôòåôøà ôïþëõ óéîèòïîéúáãéé ? òÁÓÔÏÌËÕÊÔÅ ÎÅÐÏÎÑÔÌÉ×ÏÍÕ, ÐÌÚ.
