O'Reilly logo

Oracle GoldenGate 11g Implementer's guide by John P Jeffries

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Testing Change Data Capture and Delivery

To test if the CDC is working we must make some data changes on our source database and ensure that they are propagated to and applied on the target. The following simple steps provide a basic test case that will confirm all is well:

  1. On the source database server, start a SQL*Plus session and connect to the OLTP database as the SRC user.
    sqlplus SRC/SRC@OLTP
    SQL>
    
  2. Insert a new record into the DEPT table and commit the transaction.
    SQL> INSERT INTO dept VALUES (50, 'TEST', 'LONDON');
    1 row created.
    SQL> COMMIT;
    Commit complete.
    

    Issuing a commit forces Oracle to write the transaction details to the database's online redo logs. These are subsequently read by the Extract process (EOLTP01) in real-time and written ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required