Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Stream AQ samples

Stream AQ samples

From: Binh Pham <binhpham15_at_hotmail.com>
Date: Wed, 5 Sep 2007 16:24:00 -0700
Message-ID: <BAY103-DAV6ECF7DE6E6EAA9A3A06E6D2CB0@phx.gbl>
Message-ID: <015c01c7f013$d723a1f0$46fc4e89@jpl.nasa.gov>


I need to do a quick test to verify the AQ setup between two 10.2.0.2 instances.

I've been looking for a simple sample of code which does the below, but not found one:

  1. Create the necessary users with the appropriate privileges between 2 instances.
  2. Create the queues and grants. This is for single subscriber scenario.
  3. Create the enqueue on the first instance.
  4. Dequeue on the second instance.

If you have your code, that is fine too.

Thanks for the help.

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Sep 05 2007 - 18:24:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US