Oracle Streams Setup

Oracle Streams is gaining wide popularity and hence is being used by increasing number of oracle installations. Essentially, Oracle Streams is used as a way to capture and navigate transactions from one database to another. That way we can keep two databases or specific schemas or specific tables in a synchronized state with each other. Streams can be setup in bi-directional mode i.e. all transactions from one database are propagated and applied on another database and vice versa also. As you can now imagine, using this you can keep a backup copy of schema/tables somewhere else and also going a step forward, you can offload some of your traffic on to the other synchronized database.

This note discusses step by step way to setup Oracle Streams in schema and table modes.

Implementing Schema Streams means that we can stream across all the transactions - DML/DDL originating in one Schema (user) in one database to same schema in another. Hence we can keep all the objects i.e. tables etc in two scheams in different databases in synch with each other.

Implementing Table Streams means that we can stream across transactions on specific tables (one or many) in one database into another database. Hence we can keep specific tables in sycn with each other.

Our notes are an excellent way to setup Oracle Schema and Table streams and hence to see Streams in action. This is a step by step instructions to get Oracle Streams implemented.

It is a cache 22 situation, if you do not get an opportunity to play around with Oracle Streams, then you are not going to learn it hands on and you must have some hands on experience in order to gain a job which has oracle Streams implemented.

You can now come out of these shackles and learn Oracle Streams at your home! Our personal notes teach you exactly that i.e. it is a step by step instructions using free technologies to set up Oracle Streams in Schema and Table mode. Note that we use these notes only to setup Oracle Schema and Table Streams in our test environments, so it really works! Once you have followed and setup Oracle Streams, you can try all your commands you have been waiting for.

Go to the next page and you can see our entire catalogue of Database Study material list