Transcription of Oracle Streams: Step by Step - Database Wisdom
{{id}} {{{paragraph}}}
Oracle Streams: step by step What is Oracle Streams? What is Advanced Queues (AQ)? What is Change Data Capture (CDC)? What is a Logical Change Record (LCR)? How Streams Works How do you configure Streams, AQ and CDC? How do you use Streams in your programs? Adding records automatically Adding record programmatically Pulling records off the queueWho am I Lewis R Cunningham Oracle ACE Certified PL/SQL developer Author Blogger Database Geek Member of SOUG, IOUG, ODTUG, ACMWhat is Oracle Streams? Streams enables data and event movement Movement may be within or between databases Can implement replication Data and events can be captured explicitly: programatically Implicitly: redo log Performant Log mining reduces overhead Downstreams mining reduces it even moreWhat is Oracle Streams?, cont'd Streams Features Distinct capture/propagation/apply services Message Queueing (via AQ) Publish Subscribe Rules based Capture/Transform/Apply Database integration Easy configuration Flexible Inline transformationsWhat is Oracle AQ?
Who am I Lewis R Cunningham Oracle ACE Certified PL/SQL Developer Author Blogger Database Geek Member of SOUG, IOUG, ODTUG, ACM
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document:
{{id}} {{{paragraph}}}
Oracle Application Framework Developer’s Guide, Oracle, Oracle Application Framework Developer's Guide, Wise Approach to Oracle Training, Oracle vs. SQL Server, SQL Developer, Oracle 11g New Features for Administrators - Summary Sheets, ORACLE DATA MIGRATION, Oracle to PostgreSQL Migration: a hard way, Data Modeling