Hi, We're investigating the use of Advanced Queues as a way of transferring information between OSI's PI and Oracle. The data will originate on the Oracle side and end up in PI.
We were thinking of using Oracle's Heterogeneous services and PI's ODBC driver, but ran into 2 phase commit errors (how do you tell a commit not be a 2-phase commit) and problems (ie not supported until 9iR2) with autonomous transactions and database links. We're using Oracle 81714 (soon to be 81745) on Windows. Having not used Advanced Queues before, I will look at the manuals, but is their a site or book on Advanced Queues for dummies (otherwise known as Intro to Advanced Queues in Oracle). For those who use Advanced queues, one of our developers read that "Creating a queue table in a tablespace will disable that particular tablespace for point-in-time recovery". -Do you normally put your AQ tables in a separate tablespace? - Who normally owns the queues and queue tables - system or the application schema. Any suggestions, links or books would be appreciated. Thanks, Bruce Reardon mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
