Facets Demo New Batches Starting from Saturday... 22-10-2016
Search Course Here

Live Chat
Oracle Streams Online Training

Oracle Streams


Oracle Streams enables information sharing. Using Oracle Streams, each unit of shared information is called a message, and you can share these messages in a stream. The stream can propagate information within a database or from one database to another. The stream routes specified information to specified destinations. The result is a feature that provides greater functionality and flexibility than traditional solutions for capturing and managing messages, and sharing the messages with other databases and applications. Oracle Streams provides the capabilities needed to build and operate distributed enterprises and applications, data warehouses, and high availability solutions. You can use all of the capabilities of Oracle Streams at the same time. If your needs change, then you can implement a new capability of Oracle Streams without sacrificing existing capabilities.
  • Oracle Database 11g: Administration
  • It is a 20 days program and extends up to 2hrs each.
  • The format is 40% theory, 60% Hands-on.

  • It is a 5 days program and extends up to 8hrs each.
  • The format is 40% theory, 60% Hands-on.
    Private Classroom arranged on request and minimum attendies for batch is 4.
course content
  • Introduction and Overview
    • Oracle Streams: Basic Elements
    • Capture and Event Staging
    • Staging Area Propagation
    • Rules Engine
    • Oracle Streams with Single-Source and Multiple-Source Database
    • Oracle Streams Usage: Scenarios
    • Using Oracle Streams for Upgrades and Migrations
    • Interfaces to Oracle Streams
  • Database Configuration
    • Configuring Database Parameters
    • Configuring Archive Logging
    • Supplemental Logging
    • Database Configuration with Enterprise Manager
    • Configuring Communication Between Databases
    • Configuring Multiple Streams Sites
    • Additional Preparation for File Propagation
  • Basic Objects of Oracle Streams
    • Object Types
    • Streams Events
    • Logical Change Records (LCRs)
    • Creating and Managing a Streams Administrator User
    • Staging Area Architecture
    • SYS.AnyData Queues
    • Creating a Staging Queue
    • View Interface to Queue Buffers
  • System-Created Rules
    • Using Rules in Oracle Streams
    • Generating System-Created Rules
    • Using Subset Rules with Oracle Streams
    • Row Subsetting
    • Customizing System-Created Rules
    • Negative Rule Sets
    • Rule Evaluation with Negative Rule Sets
    • Monitoring Rules
  • Enterprise Manager Interface to Oracle Streams
    • Oracle Streams Manageability Features
    • Configuring Oracle Streams
    • Streams Setup Page
    • Streams Tablespace Replication Wizard
    • Capture Management
    • Apply Management
    • Propagation Management
    • Managing Message Transformations
  • Simplified Streams Configuration
    • Simplified Configuration Procedures
    • Replicating a Single Tablespace (MAINTAIN_SIMPLE_TTS) and a Set of Tablespaces (MAINTAIN_TTS)
    • Instantiating Database Objects
    • Replicating Tables, Schemas, and Entire Database
    • Improved Diagnostics for Streams
    • Removing a Streams Queue
    • Removing All Streams Components
  • Capture Process Concepts
    • Capture
    • Implicit Event Capture
    • Capture Process Components
    • Identifying Changes to Capture
    • Logical Change Records (LCRs)
    • Data Types, DDL and DML Types Captured
    • Commands and DDLs Not Captured
    • Streams Tags and Downstream Capture
  • Configuring a Capture Process
    • Creating the Capture Process
    • Downstream Capture
    • Capture Process Parameters
    • Starting and Managing the Capture Process
    • Monitoring Log File Availability
    • Capture Process Statistics
    • Troubleshooting Capture
  • Instantiation
    • Performing Instantiation
    • Preparing for Instantiation
    • Setting the Instantiation SCN
    • Import Instantiation and Creation
    • Instantiation Using Data Pump
    • Setting the Instantiation SCN Manually
    • Instantiating a Database Using RMAN
    • Verifying Instantiations at an Apply Site
  • Propagation Concepts and Configuration
    • Directed Networks
    • Queue and Forwarding
    • Apply Forwarding
    • Queue-to-Queue Propagation
    • Propagation Job, Rules, and Scheduling
    • Creating, Managing, and Monitoring Propagation
    • Troubleshooting Propogation Configuration
  • Apply Concepts and Configuration
    • Processing Streams Events
    • Applying DDL Events
    • Error Queue
    • Required Apply User Privileges
    • Apply Process Components and Rules
    • Enqueue Destination and Execution Directives During Apply
    • Virtual Dependency Definition
    • Apply Process and Parameters
  • Transformations
    • Rule-Based Transformations
    • Declarative LCR Transformations
    • Customized Rule-Based Transformations
    • Modifying an LCR
    • Using LCR Extra Attributes
    • Creating a Rule-Based Transformation
    • One-to-many Transformations
    • Viewing and Managing Rule-Based Transformations
  • Apply Handlers
    • Creating an Apply Handler Procedure
    • Implementing a DML Handler
    • Creating an Error Handler
    • Implementing a DDL and a Precommit Handler
    • Restrictions for Apply Handler Procedures
    • Managing Apply Handlers
    • Customizing Apply Handler Actions
    • Viewing Apply Handler Information
  • Administering a Streams Environment
    • Managing the Capture Process
    • Managing Propagations
    • Managing Apply Processes
    • Starting and Stopping Streams Processes
    • Managing Streams Process Rule Sets
    • Troubleshooting Apply Failures
  • Reconfiguring the Streams Environment
    • Types of Streams Environments
    • Extending a Single-Source System
    • Extending a Multiple-Source System
    • Using Streams for Upgrades or Migrations
    • Removing Sites and Objects
  • Data Conflicts
    • What Is a Replication Conflict?
    • Error Queue
    • Types of Data Conflicts
    • Primary and Substitute Key Columns
    • Detecting Conflicts
    • Data Consistency and Convergence
    • Conflict Avoidance and Resolution Foundation
    • Site Ownership
  • Conflict resolution
    • Prebuilt Conflict Handlers
    • Resolution Columns
    • Column Lists
    • Configuring Supplemental Logging
    • Resolving Conflicts with Prebuilt and Custom Update Conflict Handlers
    • Common Data Conflict Errors
    • Print Values from a SYS.AnyData Type
    • Managing Errors
  • Message Queuing Concepts
    • Enqueuing Events
    • Subscriptions and Recipient List
    • Creating a Messaging Client
    • Streams Messages with Object Types
    • Dequeuing Messages in Streams
    • Message Handlers
    • Configuring Message Notification and Monitoring Streams Messaging
    • Queue Management Page
  • Enqueuing and Dequeing Events
    • Enqueuing a Message in Streams
    • Creating User Messages with LCRs
    • Enqueuing a User-Created LCR
    • Configuring Propagation of Non-LCR Events
    • Dequeuing LCRs and Messages
    • Applying User-Created LCR Events
    • Configuring Rule-Based Apply of Messages
    • Purging the Staging Queue
  • Best Practices and Operational Considerations
    • Best Practices for Configuring Streams
    • Archive Logging
    • Capture Process SCN Values and Checkpoints
    • Modifying FIRST_SCN and START_SCN
    • Source Queue Growth
    • NOLOGGING Operations
    • Clock Synchronization
    • Integrating Triggers with Streams
  • Troubleshooting Oracle Streams
    • Troubleshooting Capture
    • Troubleshooting Propagation
    • Troubleshooting Apply
    • Common Apply Errors
    • Troubleshooting Secure Queue Access

Oracle Streams Videos will be updated soon
To watch more Videos Click Here

Flash News

AngularJS New Batch Start From 09th OCT & 10th OCT.

Hadoop Dev New Batch Start From 10th OCT & 11th OCT.

IBM COGNOS TM New Batch Start From 11th OCT & 12th OCT.

Informatica Dev New Batch Start From 12th OCT & 13th OCT.

Mean Stack New Batch Start 13th OCT & 14th OCT.

SAP BODS new Batch Starting From 14th OCT & 15th OCT.

SAP S/4 HANA New Batch Start From 15th OCT & 16th OCT

Tableau New Batch Start From 16th OCT & 17th OCT


Facets Demo Training

Demo Schedule : 08:30P.M EST / 07:30P.M CST / 05:30P.M PST on 21st OCT & 06:00A.M IST on 22nd OCT
Email :
Rediff Bol :
Google Talk :
MSN Messenger :
Yahoo Messenger :
Skype Talk :