GG General use query
Replication is not working for a few tables between TS1CG1 to TS1PDB select * from GG_TABLE_INFO where DB_NAME='TS1CG1' and dest_db='TS1PDB'and SRC_TABLE IN('XXCPD_FACTOR_MASTER','XXCPD_ITEM_PRICING_ATTRIBUTES','XXCPD_XAAS_LIST_PRICES'); select * from GG_TABLE_INFO where DB_NAME='TS1CG1' and dest_db='TS1DMP' and SRC_TABLE IN('XXITM_EGE_BUNDLE_MAPPINGS','MTL_SYSTEM_ITEMS_B','EGO_MTL_SY_ITEMS_EXT_B','XXITM_EGE_ITEM_REQUEST','XXITM_EGE_RELATION_REQUEST','XXITM_EGE_MULTIROW_ATTRS'); select * from REPL_ALERT where REPLICAT_NAME like 'CG124%' AND DB_NAME='TS1CG1'; select * from REPL_ALERT where REPLICAT_NAME like 'CG1PD040%' AND DB_NAME='TS1CG1'; select * from REPL_ALERT where REPLICAT_NAME like 'CG1PDB01%' AND DB_NAME='TS1CG1'; select * from GG_TABLE_INFO where DB_NAME='TS1CG1' and src_table like '%XXCPD_FACTOR_MASTER%' and ...