Replication Agent objects

There are two variables in the Replication Agent database object names shown in this chapter:

prefix – represents the one- to three-character string value of the pdb_xlog_prefix parameter (the default is ra_).
xxx – represents an alphanumeric counter, a string of characters that is (or may be) added to a database object name to make that name unique in the database.

The value of the pdb_xlog_prefix parameter is the prefix string used in all Replication Agent object names.

The value of the pdb_xlog_prefix_chars parameter is a list of the non-alphanumeric characters allowed in the prefix string specified by pdb_xlog_prefix. This list of allowed characters is database-specific. For example, in Oracle, the only non-alphanumeric characters allowed in a database object name are the $, #, and _ characters.

You can use the pdb_xlog command to view the names of Replication Agent transaction log components in the primary database.

See the Replication Agent Administration Guide for details on setting up object names.

To find the names of the objects created

At the Replication Agent administration port, invoke the pdb_xlog command with no keywords:
```
pdb_xlog
```
The pdb_xlog command returns a list of all the Replication Agent objects.

Table objects

Table 4-17 lists the table that is considered a Replication Agent object.

**Table 4-17: Replication Agent tables**
Table	Database name
Procedure-active table	prefixPROCACTIVE_[xxx]

Marker objects

Table 4-18 lists the Replication Agent objects related to Replication Server markers. No permissions are granted when these objects are created.

**Table 4-18: Replication Agent marker objects**
Procedure/Table	Database name
Transaction log marker procedure	RS_MARKER[xxx]
Dump marker procedure	RS_DUMP[xxx]
Transaction log marker shadow table	prefixSH_RS_MARKER_[xxx]
Dump marker shadow table	prefixSH_RS_DUMP_[xxx]

Sequences

Table 4-19 lists the Oracle sequences that are considered Replication Agent objects.

**Table 4-19: Replication Agent sequences**
Sequence	Database name
Assign procedure call	prefixPCALL_[xxx]

Marked procedures

Table 4-20 lists the Replication Agent object that is created for each primary procedure that is marked for replication. This object is created only when a procedure is marked for replication.

**Table 4-20: Replication Agent objects for each marked procedure**
Object	Database name
Shadow table	prefixSH_xxx