Phenomenon: Customer GG do extract report error OGG-00053OGG-00053: NoextractionmapsspecifiedCause: TherearenoTABLEparametersintheE
Phenomenon: Customer GG do extract error reported OGG-00053OGG-00053: No extraction maps specifiedCause: There are no TABLE parameters in the E
Phenomenon: Customer GG do extract report error OGG-00053
OGG-00053: No extraction maps specified
Cause: There are no TABLE parameters in the Extract parameter file to specify
Source tables for which to capture data.
Action: Add one or more TABLE parameters to the Extract parameter file.
GGSCI (JOADBTEST01) 3> add extract ext2, SOURCEISTABLE
GGSCI (JOADBTEST01) 3> edit params ext2
EXTRACT EXT2
USERID goldengate, password goldengate
RMTHOST 10.0.15.107, MGRPORT 7839
Rmttask replicat, GROUP initrep
Table newolm .*;
Analysis:
Check that there are no table objects in NEWOLM.
GGSCI (JOADBTEST01) 3> info trandata NEWOLM .*
ERROR: No viable tables matched specification.
GGSCI (JOADBTEST01) 4>
SQL> select count (*) from dba_tables where owner = 'newolm'
COUNT (*)
----------
0
Solution:
For Schemas that do not have any table object, GG reports an error OGG-00053 when doing extract.