My Oracle Support Banner

How to alter propagation from queue_to_queue to queue_to_dblink (Doc ID 827473.1)

Last updated on FEBRUARY 14, 2022

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 10.2 to 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
*** ***


This note will help to alter the propagation mode from queue_to_queue to queue_to_dblink mode.

Many times as a workaround for some bug,we may need to change queue_to_queue to queue_to_dblink,so this note will help in understanding the steps which we need to follow to alter the propagation.    

Note:- For RAC instance queue_to_queue mode is always recommended.


To be used by Oracle Support Analysts and replication DBAs


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 A propagation can be defined in one of two ways:

a)  Queue-to-database link: 
 b) Queue-to-queue:

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.