Oracle XStream is a new feature of Oracle Database 11g Release 2. Though it has been developed by the Streams team and is part of the database, XStream is part of GoldenGate! And now that the GoldenGate deal has been closed, 7 days before Oracle Openworld, it’s easy to guess why XStream went out a few hours ago. This post is about XStream; it provides a Java program that uses “XStream In” to enqueue messages to a buffered queue. A…
Like with XStream InBound in my previous post, you’ll find below a simple Java for XStream Outbound. This new program subscribes to Streams captured changes. Does it sound easy ? It is, like you’ll figure out below. Step 1: Create a Sample Schema For this sample program, create a schema and a table : connect / as sysdbacreate user source identified by source default tablespace users temporary tablespace temp;grant connect,resource to source;col dbname new_value dbnameselect value dbname from v$parameterwhere name=’db_unique_name’;prompt &&dbnameconnect…