Oracle Streams 11g Data Replication (Osborne ORACLE Press by Kirtikumar Deshpande

By Kirtikumar Deshpande

Grasp Oracle Streams 11g Replication let real-time info entry and information sharing throughout your allotted framework utilizing the specialist details during this Oracle Press advisor. Oracle Streams 11g information Replication explains find out how to arrange and administer a unified company facts sharing infrastructure. easy methods to seize, propagate, and observe database alterations, rework info, and deal with info conflicts. tracking, optimizing, and troubleshooting options also are lined during this accomplished quantity. comprehend Oracle Streams elements and structure achieve in-depth wisdom approximately taking pictures, propagating, and utilizing info manipulation language (DML) and knowledge definition language (DDL) adjustments methods to entry and alter the contents of Logical swap documents construct customized approaches for facts alterations Configure Oracle Streams replication for the database, schemas, and tables track Oracle Streams functionality for greater throughput deal with and visual display unit Oracle Streams utilizing Oracle firm supervisor Grid keep watch over examine from a number of functional examples and scripts

Show description

Read Online or Download Oracle Streams 11g Data Replication (Osborne ORACLE Press Series) 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 allow real-time details entry and information sharing throughout your disbursed framework utilizing the specialist details during this Oracle Press consultant. Oracle Streams 11g facts Replication explains how you can arrange and administer a unified firm info sharing infrastructure.

Oracle Application Express 4 Recipes

Oracle software show four Recipes presents an example-based method of studying program exhibit - the ground-breaking, speedy software improvement platform integrated with each Oracle Database license. The recipes layout is perfect for the quick-study who simply desires an exceptional instance or to kick begin their pondering and get pointed within the correct course.

Extra info for Oracle Streams 11g Data Replication (Osborne ORACLE Press Series)

Example text

In addition to the standard messaging features, it provides transactional support to the messages. Applications can manage data as well as the messages in a single transaction. Oracle Streams is like a Swiss army knife; you can use it to solve a number of business problems. The list of possible applications of Oracle Streams discussed in this chapter is not exhaustive, so you might even find yet another application for it in your particular business.

The data pump and export/import utilities can set the instantiation SCN for the table at the destination database when importing data. You can also use a supplied procedure to set the instantiation SCN for the tables in the destination database. The instantiation SCN controls which LCRs containing database changes are applied to the destination database by the apply process and which LCRs are ignored. If the commit SCN in the LCR for the source table is greater than the instantiation SCN for the table in the destination database, then the apply process will apply the change to the table.

In situations where the application maintains data integrity outside the Oracle database, and the tables do not have primary key or unique constraints, it becomes necessary to configure adequate supplemental logging. Sometimes it requires supplemental logging of all columns in the table. Note Supplemental logging is always configured at the source database irrespective of the capture process location—local or downstream. Supplemental logging can be configured at the database level or at the table level.

Download PDF sample

Rated 4.53 of 5 – based on 15 votes