In this recipe you will learn how to set up an Oracle GoldenGate configuration with a deferred apply state target database. You will also learn about some scenarios where such a configuration can be useful.
For this recipe we will refer to the setup done in the Setup a simple GoldenGate replication configuration between two single node databases recipe in Chapter 2, Setting up GoldenGate Replication. For the purpose of this recipe, we will modify the replication to replicate only the records for the EMP table in the SCOTT schema. We will also modify the structure of the EMP table in the target database to add the following two new columns:
SOURCE_COMMIT_TIME TIMESTAMPTARGET_COMMIT_TIME TIMESTAMP
This can be done as follows:
SQL> ALTER TABLE EMP ADD(SOURCE_COMMIT_TIME TIMESTAMP); Table altered. SQL> ALTER TABLE EMP ADD(TARGET_COMMIT_TIME TIMESTAMP); Table altered.