Task 6: Verify GoldenGate Replication

Once you have replication set up, verify that replication is working.

Update data in the replicated tables by inserting, updating, and/or deleting rows in the Oracle database. For example, you add a new row to the customer table in the Oracle database:

SQL> INSERT INTO customer VALUES('C000000002', 'John', 'Beavans', 'Pretty Villas Down Town', '[phone]');

On the TimesTen database, select from the replicated tables and verify that the changes are being propagated from the Oracle database. In this example, it shows the same row is propagated to the customer table in the TimesTen database.

Command> select * from customer;
<C000000001, Fred, Bloggs, Nice Villas Pleasant Town, [phone]>
…..
….
…..
<C000000002, John, Beavans, Pretty Villas Down Town, [phone]>