OGG-02636 The TABLE specification for the source table does not include a catalog name. The database requires a catalog name

Hi,

Sometimes You can get ” OGG-02636 The TABLE specification ‘TABLE MehmetSalih.”TestTable”‘ for the source table MehmetSalih.TestTable does not include a catalog name. The database requires a catalog name ” error.

 

Details of error are as follows.

OGG-02636  The TABLE specification 'TABLE MehmetSalih."TestTable"' for the source table MehmetSalih.TestTable does not include a cat
alog name. The database requires a catalog name

 

This error is related with the Container and Pluggable database ( PDB ) .

 

 

To solve this error, you should use the PDB Name before table name as follows.

TABLE PDB_NAME.SCHEMA_NAME.TABLE_NAME;

 

Or you can use the SOURCECATALOG parameter in the Extract or Replicate parameter file with PDB NAME as follows.

SOURCECATALOG PDB_NAME

 

 

 

Do you want to learn Oracle Goldengate from scratch, then read the following Goldengate Tutorial articles.

https://ittutorial.org/goldengate-tutorials-oracle-for-beginners/