Why the replication of Advanced Queuing (AQ) tables is not recommended?
Here are main reasons the replication of Advanced Queuing (AQ) tables is not recommended:
The data from AQ tables is used for populating some replicating tables on source so replicating the AQ tables to target does not make logical sense. You will not be able to use the AQ table on target to populate the data on target table. The target table will get its data from replication and not from dequeuing the advanced queue (if you are replicating one).
Though AQ tables can be replicated in a High Availability environment, they undergo purging on source so the content is always in a state of flux. For the same reason, it does not make sense to replicate them in a one-way replication as the content of AQ tables is temporary.
