There are six types of Oracle database objects used for Replication Agent transaction log components:
tables
stored procedures
triggers
indexes
sequences
synonyms
The Replication Agent transaction log uses several tables, both as base objects and as shadow tables for marked primary tables and procedures. All table components of the transaction log contain at least one index. Some contain more than one index. Public synonyms are created for tables and sequences.
Stored procedures are used by the Replication Agent transaction log to capture transactions for replication, convert the DATE data type, and perform various other log operations.
Triggers are used to capture the insert, update, and delete operations in marked primary tables.
Sequences are used to assign unique operation and transaction numbers to the primary operations recorded in the transaction log.
