Verifying the data transfer on the target system
This recipe will show you how to verify data transfer on a target system.
Getting ready
For this recipe we will use the continuous replication setup for the SCOTT
schema done in Setting up a simple GoldenGate replication configuration between two single node databases earlier in this chapter.
How to do it...
Perform the following steps in the source database:
- Check the number of employees whose salary is greater than 3000:
SQL> select * from EMP where sal>3000; EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO ----- ----- --- --- -------- --- ---- ------ 7839 KING PRESIDENT 17-NOV-81 5000 10
- Perform some updates in the source database. Here we increase the salary for all employees by 1000:
SQL> update SCOTT.EMP ...
Get Oracle GoldenGate 11g Complete Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.