Shulou(Shulou.com)06/01 Report--

Recently started to work on the OGG project, encountered a problem in the testing process. After using CTAS to create a table with data in it, and then deleting the table using delete from xxx;, the replicat process is abnormal. Check the ogg log and check the official website to find the reason.

Official document number How to Capture the DML (s) Executed by a DDL Trigger (OGG) (document ID 1509900.1) solution SOLUTIONBy 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 testing process: connect cytdas/cytdascreate table oggtest as select * from dba_users; checks that the ogg process is normal and the data synchronization is normal. The destination side of the delete from oggtest; found the replicat process abend, and checked the log to find the ORA-01403 error. This is not BUG, not BUG, it is the design requirement of OGG, we just need to pay attention to it in our work. But get rid of this watch and continue testing.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.