Show me an simple example of Oracle Streams?

Question

I am just getting started with on a project and hope to use Oracle streams.

I am looking for a straight-forward, hello-world type of example using Oracle Streams. Can you point me to a tutorial or show me an example?

Thanks

Burseraceous

Answer 1

A pretty good resource is the blog: We Do Streams

A good starting point is: Oracle Streams One Way Table Replication 101

Rutharuthann

This is an excellent tutorial. Thanks, it's exactly what I was looking for. There is a PPT presentation out there claiming to be 'step by step' but it's not very helpful. The One Way Table Replication 101 is what I needed. – Burseraceous

Answer 2

You have to do your research about what kind of Streams setup you want to make. For a downstream setup (this means that the capture of changes in the database you use as source, will be made in the destination system) you can follow this simple guide.

You can find details about each step of the setup at oracle's site.

Nail

What if the links go down? Could you summarise what they say in your answer to guard against that? – Tabret

there are alternatives. You can create multiple capture apply and propagation processes and also define different destinations (search for log_archive_dest_1 ). In case the propagation to a destination fails for whatever reason, another one could start (log_archive_dest_2 with log_archive_dest_state_2 = ALTERNATE) . Check docs.oracle.com/cd/B28359_01/server.111/b28294/… . In case you don't need to have a livestream (the same data on both DBs without any delay) then you can recover your system. – Nail

@WaiHaLee - The site is down now, when I needed it :( – Dolores