While creating an integrated extract in Goldengate 12C on a Puggable database 12C I came across the follow error, stating that the needed catalog name is mandatory and was not being informed.
ERROR OGG-02636 Oracle GoldenGate Capture for Oracle, ext1.prm: The TABLE specification ‘TABLE table_name’ for the source table ‘table_name’ does not include a catalog name. The database requires a catalog name.
There is two ways to solve this case: The first , besides less indicated, is to add the name of pluggable database (Catalog) before the owner name on the table maps, for example:
GGSCI (host1.net) 1> edit param ext1
–Tables
TABLE PDB_NAME.SCHEMA_OWNER.TABLE_NAME;
Not really enjoying this solution and after searching for long hours without any other result , our friend Maiquel DC indicated a parameter that identifies the catalog name for all tables in the extract ;
Add the following parameter in extract configuration file:
GGSCI (host1.net) 1> edit param ext1
–Parameters
SOURCECATALOG PDB_NAME
Thats all folks.
Dieison.
Pingback: Behind the scene – Integrated Capture – |GREP ORA