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:
sqlplus SRC/SRC@OLTP SQL>
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 ...