The new Oracle XSTream

Oracle provides a new API called XSTream that is based on Oracle Streams and used to replicate data between Oracle Databases. It is also possible to replicate to other databases using Oracle Gateway, JMS, or directy with an third application consuming messages from a queue.

XSTream makes use of OCI or Java interface to capture and propagate data.

The configuration of XTream is done using DBMS_XSTREAM_ADM and it works with XSTream Outbound and XTream Inbound.

One simple example of how to configue an XTream Outbound for table HR.EMPLOYEES and HR.JOBS and also

DECLARE
tables DBMS_UTILITY.UNCL_ARRAY;
schemas DBMS_UTILITY.UNCL_ARRAY;
BEGIN
tabs(1) := 'HR.EMPLOYEES';
tabs(2) := 'HR.JOBS';
my_schemas(1) := 'HR';
DBMS_XSTREAM_ADM.CREATE_OUTBOUND(
server_name => 'MY_FIRST_OUT',
table_names => tabs,
schema_names => my_schemas);
END;
/

I will post more examples soon....

Best Regards,
Paulo Portugal