Forum Stats

  • 3,817,447 Users
  • 2,259,334 Discussions
  • 7,893,776 Comments

Discussions

AQ To A Remote Database

3004
3004 Member Posts: 204,171 Green Ribbon
I am using AQ to pass information from a local database to a remote database. I have no problem creating queues, enqueuing and dequeing etc within a single database.

My problem is creating a queue table in both databases that use the same object type. I have a queue in the local base that has a subscriber of a queue in the remote database.
If I am passing an object from a queue in the local database then the queue in the remote database must be set up to receive the same type of object. So how do I refer to an object type created in a different database ?

Regards

Adrian

Comments

  • 3004
    3004 Member Posts: 204,171 Green Ribbon
    You need to a create queue table in both databases with the same object type and then specify the remote queue as a subscriber to the queue on the source database. AQ will propagate the messages from the source queue to destination queue.

    There was a sample script posted earlier on this forum http://technet.oracle.com:89/ubb/Forum96/HTML/000005.html
    null
  • 3004
    3004 Member Posts: 204,171 Green Ribbon
    YOur remote database queue must have a queue table of the same type. You have to create the queue at your remote db and add it as a subscriber to your local queue in the local database.

    I believe there is a thread in this forum that describes the full set up.
    http://technet.oracle.com:89/ubb/Forum96/HTML/000005.html
  • 3004
    3004 Member Posts: 204,171 Green Ribbon
    <BLOCKQUOTE><font size="1" face="Verdana, Arial, Helvetica">quote:</font><HR>Originally posted by bnainani ():
    You need to a create queue table in both databases with the same object type and then specify the remote queue as a subscriber to the queue on the source database. AQ will propagate the messages from the source queue to destination queue.

    There was a sample script posted earlier on this forum http://technet.oracle.com:89/ubb/Forum96/HTML/000005.html
    <HR></BLOCKQUOTE>

    I am setting up the queues correctly in their own instances and I have created the schedule to carry out the propagation.

    The key point about my query is if I have created an object type in one database how do I refer to it from the remote database so I can create the queue table in the remote database for that object type i.e. I am struggling to create two queues using the same object type.
  • 3004
    3004 Member Posts: 204,171 Green Ribbon
    You don't have to refer to the type in the source database. All you need to do is to create the same type again on the remote database. The type must be structurally equivalent to the one on the source database. The name of the type may be same or different from that on the source.

    null
This discussion has been closed.