O'Reilly logo

Oracle 11g Streams Implementer's Guide by Eric Yen, Ann L. R. McKinnell

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Understanding your Instantiation tools

In Chapter 1, All the Pieces: The Parts of an Oracle 11g Streams Environment, we discussed Instantiation and Instantiation SCN theoretically. In our examples in this book, we use Data Pump for Instantiation. We provide a quick review of Data Pump commands and configuration here to prepare for its use when we begin building Streams. We also provide practical examples of how to go about setting the Instantiation SCN manually, should you need to do so.

Using Data Pump to Instantiate

If you plan to use Data Pump to instantiate your target sites, you will need to create work directories in which Data Pump will create and access the resulting dump file for export and import. The naming convention you use is up to ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required