In this chapter, we have seen the steps necessary to prepare our databases to support Streams, and our tools to instantiate our Streamed objects.

We have looked at a way to verify our network connectivity and throughput with the ping and tracert commands.

We configured our database initialization parameters to support Streams processes and memory structures. We enabled archive logging and supplemental logging to support Streams capture and apply.

We discussed configuring our Streams user(s) for trusted and untrusted security environments as well as best practices for database links.

We then addressed creating directories objects to be used during instantiation with Data Pump and how to manually set Instantiation SCNs for corresponding capture and Apply processes.

And last but not least, we covered how you can create the Oracle Demo Schemas in your database so that you can practice along with us, as we go through examples of setting up the different Stream configurations.

So, hop aboard, grab your paddles (or keyboards in this case) and let's float onto Chapter 4 where we will bring this all together with a uni-directional scenario and start Streaming!