Best Practices from Oracle Development's A‑Team

Oracle GoldenGate Best Practices: Creating History Tables


Oracle GoldenGate'’s flexible architecture provides built-in functionality for the transformation of captured transactional data. This data manipulation may take place anywhere in the Oracle GoldenGate stream; but is most commonly performed in the Change Data Apply (Replicat) process during data apply to the target.

Main Article

In this document we shall use this functionality to build (1) a classic operation history table where all activity is recorder, and (2) a history table that records only data modifications.

It is assumed that the reader has knowledge of the Oracle GoldenGate application, including how to install and configure the product; therefore, this information is not presented.

The complete document can be found on the Oracle Support site under the document ID:1314698.1

Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.Captcha