Oracle Streams规则应用与配置方法.pdfVIP

Objectives

Aftercompletingthisson,youshouldbeabletodothe

following:

•Identifythedifferenttypesofsystem-createdru

•UseaneiverulesettopreventaStreamsclientfrom

performingitstaskonanindividualobject

•Usesubsetrutorestrictthedatathatflowsthrough

thestream

•Customizesystem-createdru

•Querythedatadictionaryforinformationabout

system-createdru

UsingRuinOracleStreams

•ThefollowingStreamsclientsuseruandrulesets:

–Captureprocess

–Propaionjob

–Applyprocess

–Messagingclient

•ThesamerulesetcanbeusedbymultipleStreams

clientsinthesamedatabase.

•MultipleruinarulesetarecombinedwiththeOR

operator.

UsingRuinOracleStreams

•Youcanuserutodefinethegranularityatwhicha

captureprocess,propaionjob,orapplyprocess

replicatesdata.

•Levelsofgranularity:

–Database

–Schema

–Table

–Subsetofrowsinatable

–DMLoperationsonly

–DDLoperationsonly

–Subsetofoperationsthatareperformedagainstatable

GeneratingSystem-CreatedRu

YouuseproceduresintheDBMS_STREAMS_ADMpackageto

generatesystem-createdru.

•Foraspecificcomponent:

–ADD_TABLE_RU

–ADD_SCHEMA_RU

–ADD_GLOBAL_RU

–ADD_SUBSET_RU

–ADD_*_PROPAN_RU

•Formultiplecomponents:

–MAINTAIN_SIMPLE_TTS,MAINTAIN_TTS

–MAINTAIN_GLOBAL

–MAINTAIN_SCHEMAS

–MAINTAIN_TAB

GeneratingSystem-CreatedRu

TheproceduresintheDBMS_STREAMS_ADMpackagethat

generatesystem-createdrualsoperformthefollowing

actions:

•Createacap