I'm doing a complete schema level replication which has around 600+ tables. However I'm good on 200+ tables however 350+ tables are replicated because of
"ASN7624I "Q Apply" : "ASNUTGT" : "BR00000" : Found "1" secondary unique index(es) for Q subscription "TABLESAMPLE0001" (receive queue "ASNUSRC.SAMPLE_TO_ASNUTGT.CMSDBOC.DATA", replication queue map "ASNUSRC_TO_ASNUTGT")."
All tables having secondary indexes is not getting replicated.
What am I missing here ?
Already my Capture and apply program is running. Is there a way I can re-initiate these tables alone without stop and start ?
Appreciate for any support !!!
This is how I create the subscription for whole Schema...
CREATE SCHEMASUB SAMPLE_SCHMEA_NEW SUBTYPE U REPLQMAP ASNUSRC_TO_ASNUTGT FOR TABLES OWNER LIKE ********OPTIONS ASNUNI ;