1.5.3 TranData

This topic provides information about TranData.

Oracle GoldenGate TRANDATA enables supplemental logging on source tables so that sufficient row information (such as primary or unique keys) is written to the transaction logs. This allows GoldenGate Extract to correctly capture and replicate INSERT, UPDATE, and DELETE operations.

Figure 1-48 Trandata

Description of "Figure 1-48 Trandata"

• Search for Trandata (Before Addition) : Searching the source database to check whether TRANDATA is already enabled on the specified tables before adding it.

  Figure 1-49 Search for Trandata (Before Addition)

  
  

  
  Description of "Figure 1-49 Search for Trandata (Before Addition)"

  
  

  Figure 1-50 Search for Trandata (Before Addition)

  
  

  
  Description of "Figure 1-50 Search for Trandata (Before Addition)"

  
  
• Add Trandata: Enables TRANDATA on selected schemas to ensure the necessary supplemental logging is available for accurate GoldenGate replication.

  Figure 1-51 Add Trandata

  
  

  
  Description of "Figure 1-51 Add Trandata"

  
  
• Search for Trandata (After Addition)

  Figure 1-52 Search for Trandata (After Addition)

  
  

  
  Description of "Figure 1-52 Search for Trandata (After Addition)"

  
  

  Figure 1-53 Search for Trandata (After Addition)

  
  

  
  Description of "Figure 1-53 Search for Trandata (After Addition)"

  
  

Note:

When adding TranData for an existing replication, the Extract process must be stopped and restarted after all required TranData entries are configured.