In this chapter, we demonstrated how to set up a single-source (uni-directional) streamed environment.

We demonstrated how to use the EM DBConsole Streams "Wizard" to configure your streamed environment and/or generate scripts that you can run manually.

We walked through the steps to manually configure your streamed environment using PL/SQL code and provided code examples.

We addressed the different DBMS_STREAM_ADM subprograms that can be used to configure different levels of streaming. These being table level, schema level (as in our example), tablespace level, and global (database) level. We also touched on the use of the DBMS_STREAM_ADM.MAINTENANCE_* subprograms that are called by EM DBConsole to configure Streams and/or generate scripts, and the importance of understanding how these subprograms work "under the covers".

We also discussed sequence and trigger calls, what we can expect, and how to control them in a streamed environment.

In the next chapter, we will demonstrate how to stream both ways. Like canoeing up-stream, it takes a bit more work, but using the paddle helps.