Oracle GoldenGate Error Messages

OGG-01075

The table object ID cannot be used to look up the table entry if the tables were added via a SOURCEDEFS file


Cause

The definitions file prevents correct table name resolution. DB2 LUW only gives the tablespace ID and the table object ID in the log records. To be able to resolve the actual owner and table name as they are given in the TABLE parameter, Extract looks up the tablespace and object IDs in the database catalog. The IDs are used in an ODBC query against the system catalog tables to retrieve the table name. This process is not possible if a SOURCEDEFS or TARGETDEFS file is used as input.


Action

Remove the SOURCEDEFS or TARGETDEFS parameter.