ADD TRACETABLE

Use ADD TRACETABLE to create a trace table in the Oracle Database. The trace table must reside in the schema of the Oracle GoldenGate Extract user, as configured with the USERID or USERIDALIAS parameter. The trace table prevents Replicat transactions from being extracted again in a bidirectional synchronization configuration.

Use the DBLOGIN command to establish a database connection before using this command.

Table 2-1 Description of trace table

Name	Null?	Type	Description
`GROUP_ID`	`NOT NULL`	`VARCHAR2(8)`	The name of the Replicat group or special run process.
`DB_USER`		`VARCHAR2(30)`	The user ID of the Replicat group or special run process.
`LAST_UPDATE`		`DATE`	The timestamp of the transaction.

Syntax

ADD TRACETABLE [[container.]owner.table]

container

The pluggable database, if the database is a multitenant container database (CDB).

owner.table

Optional, use only to specify a trace table with a name that is different from the default of GGS_TRACE. The owner must be the same owner that is specified with the USERID or USERIDALIAS parameter in the Extract parameter file.

To use the default name, omit this argument. Whenever possible, use the default table name. When using a trace table name other than the default of GGS_TRACE, specify it with the TRACETABLE parameter in the Extract and Replicat parameter files. Record the name, because you will need it for the parameter files and to view statistics or delete the table, see TRACETABLE | NOTRACETABLE.

Examples

The following adds a trace table with the default name of GGS_TRACE.

ADD TRACETABLE

The following adds a trace table with a user-defined name of ora_trace.

ADD TRACETABLE ora_trace