Oracle 11g Streams Implementer’s Guide by Ann L.R McKinnell

By Ann L.R McKinnell

This publication has an instructional strategy that gives either theoretical reasons and functional step by step examples utilizing general Oracle demo schemas. step by step examples contain use of either company supervisor and the SQLPLUS command-line interface. The authors have mixed their stories of operating with shoppers in Oracle help, Oracle education and schooling, and Oracle consulting, to spot the commonest components of misunderstanding and misinterpretation skilled via Oracle Streams clients. This e-book highlights those parts and specializes in bringing readability and realizing to the reader. This e-book is for clients who've implemented,or are approximately to implement,a allotted database surroundings utilizing Oracle Streams replication. The reader is anticipated to have an intermediate figuring out of Oracle database expertise. This publication is principally meant to be used by means of: Oracle Database directors chargeable for the implementation and upkeep of an Oracle Streamed atmosphere, approach and Database Architects chargeable for the layout of dispensed database environments utilizing Oracle Streams. Readers with constrained wisdom of uncomplicated Oracle database expertise can take advantage of Chapters 1 and a pair of, which conceal Oracle Streams elements and layout concerns.

Show description

Read or Download Oracle 11g Streams Implementer’s Guide PDF

Best databases books

Teradata RDBMS SQL/Data Dictionary Quick Reference

This publication is a brief reference for the SQL dialect supported via the Teradata Relational Database administration procedure. The ebook is usually a short connection with the supported information description words for the Teradata RDBMS and the information Dictionary. The viewers for this quickly reference is all clients of Teradata SQL who want speedy, non-detailed information regarding tips to constitution a SQL assertion.

Access Forms & Reports For Dummies

Create queries that make kinds and studies worthwhile boost types to entry the knowledge you wish and make studies that make feel! in case you notion you needed to use a spreadsheet software to supply experiences and varieties, wager what! entry can end up great-looking varieties and experiences that truly convey what is going on together with your info -- in the event you know the way to invite it well.

Additional info for Oracle 11g Streams Implementer’s Guide

Example text

ANYDATA and TYPED refer to the payload datatype of the message handled by the queue. ANYDATA datatype. A TYPED queue has a specific datatype (such as Varchar2, CLOB, BLOB, Number). To determine the payload type of a queue, query the OBJECT_TYPE column of the DBA_QUEUE_TABLES view. select owner, queue_table, object_type from dba_queue_tables; The Oracle memory segment used by buffered queues is part of the STREAMS_POOL in the SGA. The type of queue used by Streams depends on the type of LCR that is being stored.

Think of it this way, the owner of the queue runs and controls it. No other users or processes may use a secure queue unless the owner allow it by granting explicit privileges to the user. For the purpose of this book, all queues will be secure queues. This is compared to an unsecure queue which any session or process is allowed to use. So, how does Propagate know when to do its job? In Oracle 11g, Scheduler controls when the Propagation takes place (in previous versions, it was accomplished via regular database jobs).

A situation can arise where there is conflict caused by DML/DDL originating from one or more databases acting on the exact same data at nearly the same time. To overcome this conflict situation, conflict resolution must be implemented to determine which data changes should be kept and which should be discarded. Below are some illustrated examples of multiple-source configurations. Bi-directional/N-way/Master-to-Master Bi-directional, N-way, Master-to-Master are all names for essentially the same thing.

Download PDF sample

Rated 4.92 of 5 – based on 49 votes