Diagram
From the diagram, we can see two following point:
queue1 and queue2 should enable both enqueue and dequeue operation.
when dequeue from queue2@db2, consumer name should be same as subscriber in queue@db1
Implement scirpt
DB1
conn / as sysdba@db1 create role my_aq_adm_role ; grant connect,resource, AQ_ADMINISTRATOR_ROLE to my_aq_adm_role;
create role my_aq_user_role; grant connect, resource,aq_user_role to my_aq_user_role; exec d......
阅读全文