Oracle GoldenGate XSTREAMS

With the acquisition of GoldenGate, Oracle 11gR2 incorporates GoldenGate XSTREAMS technology providing client applications with the ability to insert and extract LCR datatypes directly into an implicit or explicit Stream.

Note

To use the XSTREAMS API's, you must purchase an Oracle GoldenGate product license. See the Oracle GoldenGate documentation at http://download.oracle.com/docs/cd/E15881_01/index.htm.

The following lists views that supply helpful information for XSTREAMS:

  • ALL_APPLY
  • ALL_APPLY_ERROR
  • ALL_XSTREAM_INBOUND
  • ALL_XSTREAM_INBOUND_PROGRESS
  • ALL_XSTREAM_OUTBOUND
  • ALL_XSTREAM_OUTBOUND_PROGRESS
  • ALL_XSTREAM_RULES
  • DBA_APPLY
  • DBA_APPLY_ERROR
  • DBA_APPLY_SPILL_TXN
  • DBA_XSTREAM_INBOUND
  • DBA_XSTREAM_INBOUND_PROGRESS
  • DBA_XSTREAM_OUTBOUND
  • DBA_XSTREAM_OUTBOUND_PROGRESS
  • DBA_XSTREAM_RULES

XTREAMS is built on Oracle Streams infrastructure and thus can take advantage of Oracle Streams' functionality and flexibility.

The Oracle database is configured to support XSTREAMS using the DBMS_XSTREAMS_ADM package subprograms. Specialized server processes are configured to handle inbound and outbound traffic to standard Oracle Streams queues. Outbound server processes can be created to dequeue from an existing Streams queue, or its own queue. Inbound server processes are created with their own Streams queue which can then be configured for use via normal Streams apply rule creation. These server processes are accessed via the OCI or Java API function interfaces.

XSTREAMS provides the ability to share information across a heterogeneous environment with excellent flexibility, usability, and performance. This functionality can be used as an alternative to replicating with Oracle Heterogeneous Gateways, and Java Messaging Service(JMS) clients.

Note

For more information on XSTREAMS, please reference the Oracle Database XSTREAMS Guide.

Special Documentation Notes:

The DBMS_XSTREAM_ADM package is documented in the Oracle Database XSTREAMS Guide rather than the Oracle PL/SQL Packages and Types Reference.

XSTREAM OCI interfaces are found in the Oracle Database XSTREAMS Guide.

XSTREAM Java API's are found in the XSTREAM Java API Reference.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset