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/