Oracle Streams 11g Data Replication by Kirtikumar Deshpande

By Kirtikumar Deshpande

Grasp Oracle Streams 11g Replication permit real-time info entry and knowledge sharing throughout your allotted framework utilizing the professional details during this Oracle Press advisor. Oracle Streams 11g info Replication explains how one can organize and administer a unified company facts sharing infrastructure. the best way to trap, propagate, and follow database adjustments, remodel facts, and deal with info conflicts. tracking, optimizing, and troubleshooting recommendations also are coated during this accomplished quantity. comprehend Oracle Streams parts and structure achieve in-depth wisdom approximately shooting, propagating, and utilizing info manipulation language (DML) and information definition language (DDL) adjustments the way to entry and regulate the contents of Logical swap files construct customized tactics for facts differences Configure Oracle Streams replication for the database, schemas, and tables music Oracle Streams functionality for more advantageous throughput deal with and video display Oracle Streams utilizing Oracle company supervisor Grid keep watch over study from numerous useful examples and scripts

Show description

Read or Download Oracle Streams 11g Data Replication PDF

Similar oracle books

Oracle PL/SQL Programming 4Th Edition

За последние 10 лет книга Oracle PL/SQL Programming издательства O'Reilly's стала бестселлером среди книг по PL/SQL, процедурному языку базы данных Oracle. Снабженная примерами и полезными рекомендациями книнга является незаменимой как новичкам, так и гуру, как разработчикам на Oracle kinds, так и администраторам - используйте PL/SQL на полную мощь.

Oracle Streams 11g Data Replication

Grasp Oracle Streams 11g Replication let real-time details entry and information sharing throughout your dispensed framework utilizing the professional details during this Oracle Press advisor. Oracle Streams 11g info Replication explains how you can arrange and administer a unified firm facts sharing infrastructure.

Oracle Application Express 4 Recipes

Oracle program convey four Recipes presents an example-based method of studying program show - the ground-breaking, swift software improvement platform incorporated with each Oracle Database license. The recipes layout is perfect for the quick-study who simply wishes a superb instance or to kick commence their pondering and get pointed within the correct course.

Additional info for Oracle Streams 11g Data Replication

Sample text

This setting instructs Oracle to add rules to the positive rule set associated with the capture process. If there is no positive rule set already assigned, Oracle creates one. The procedure is run under the Streams Administrator (STRMADMIN) account. The procedure displays the rule names that Oracle created to capture the DDL and DML changes using two optional out parameters. There is one rule each to capture DDL and DML changes. "SCOTT14" PL/SQL procedure successfully completed. We run the following SQL query against the DBA_STREAMS_RULES view to see more information about the rules we just created: SQL> select rule_name, 2 rule_type, 3 rule_set_type, 4 rule_set_name, 37 38 Oracle Streams 11g Data Replication 5 6 7 8 streams_type, streams_name from dba_streams_rules where rule_name in ('SCOTT13','SCOTT14'); RULE_NAME RULE_TYPE RULE_SET_TYPE RULE_SET_NAME STREAMS_TYPE STREAMS_NAME --------- -------- ------------ --------------- ------------ -------------SCOTT14 DDL POSITIVE RULESET$_15 CAPTURE DBXA_CAP SCOTT13 DML POSITIVE RULESET$_15 CAPTURE DBXA_CAP We see that Oracle assigned both these rules, one to capture DDL changes and the other to capture DML changes, to the positive rule set named RULESET$_15.

If the negative rule set does not evaluate to TRUE, then the positive rule set is evaluated, if present. A rule can be part of one of more rule sets. A rule set can contain one or more rules. A Streams client can have at least one rule set, and at most two rule sets, with the exception of synchronous capture, which can only have one positive rule set. The rule set evaluation flow is depicted in Figure 3-1. Notice the difference in the behavior of the Streams client when it does not have a rule set and when it has an empty (a rule set that has no rules) positive rule set.

In addition, rule-based content routing is also supported. The Oracle Streams AQ system supports message transformations to reformat the message before it is delivered to the subscriber. Minimizing Downtime During Database Upgrades As newer releases of Oracle Database are introduced, the support for older releases eventually comes to an end. The databases need to be upgraded to the newer release, Chapter 2: Using Oracle Streams often to stay supported, even if the applications do not utilize newer or improved features offered by the new release.

Download PDF sample

Rated 4.15 of 5 – based on 8 votes