Sign In Start Free Trial
Account

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying Oracle 11g Streams Implementer's Guide
  • Table Of Contents Toc
Oracle 11g Streams Implementer's Guide

Oracle 11g Streams Implementer's Guide

4.5 (8)
close
close
Oracle 11g Streams Implementer's Guide

Oracle 11g Streams Implementer's Guide

4.5 (8)

Overview of this book

From smaller businesses through to huge enterprises ñ users all over the world often require access to data 24 hours a day. Distributed database systems proliferate the world of data sharing providing an ability to access real-time data anywhere, anytime. Oracle Streams, a built-in feature of the Oracle database, is a data replication and integration feature critical to the success and wellbeing of enterprises in today's fast moving economy. This book provides the reader with solid techniques to master Oracle Streams technology and successfully deploy distributed database systems. This book quickly goes over the basics and gets you up and running with a simple Oracle 11g Streams environment. It will serve as an excellent companion to the Oracle Streams Administration Guide. It is intended for Oracle database architects and administrators, and provides in-depth discussion on must-know information for the design, implementation, and maintenance of an Oracle Streams environment. The book does not attempt to regurgitate all the information in the Oracle Streams Administration Guides, but rather provides additional clarification and explanation of design, implementation, and troubleshooting concepts that are often elusive in Streams documentation. It also identifies helpful tools and Oracle resources to add to your knowledge base, as well as tried and tested tricks and tips to help you tame Oracle Streams. The book starts by introducing and explaining the components of Oracle Streams and how they work together. It then moves on logically, helping you to determine your distributed environment requirements and design your Streams implementation to meet those requirements. Once these concepts are discussed, the book moves to configuration and basic implementation examples to help solidify those concepts. It then addresses advanced features such as tags, down-stream capture, and conflict resolution. You then move on to maintenance techniques such as documenting the environment, effectively planning and implementing changes to the environment, and monitoring and troubleshooting the environment. When you have studied the techniques and completed the hands-on examples, you will have an understanding of Oracle Streams' core concepts and functionally that will allow you to successfully design, implement, and maintain an Oracle Streamed environment.
Table of Contents (14 chapters)
close
close
Oracle 11g Streams Implementer's Guide
Credits
About the Authors
About the Reviewers
Preface

Chapter 4. Single-Source Configuration

The stream flows one way: Downhill

In this chapter, we will look at configuring single-source streams replication using Enterprise Manager (EM) DB Console (this can also be applied if you are using Enterprise Manager Grid Control). We will also provide the PL/SQL API calls being issued behind the scenes. The PL/SQL for these calls can be copied to a script and used to configure Streams from the command line as well. This chapter is organized as follows:

  • The Enterprise Manager: This takes you step-by-step through the EM Streams setup wizard, using a schema-level replication example

  • The code behind the curtain: A step-by-step walk-through the PL/SQL code that configures the Stream

  • Sequences, and triggers, and apply: Points out expected behavior of sequence and triggers in our example, as well as special case considerations

  • Other levels at which to replicate: Provides a brief description of other replication levels that can be used and the beauty of the...

CONTINUE READING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
Oracle 11g Streams Implementer's Guide
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected

Close icon Your notes and bookmarks

Confirmation

Modal Close icon
claim successful

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon