Oracle10g stream : :dml.get_command_type and lcr.get_command_type
Oracle10g 10.2.0.4 , RAC , Linux AS 5.3
being
DBMS_RULE_ADM.CREATE_RULE(
rule_name=>'fbtest_rule_x',
condition=>'(:dml.get_command_type() = ''INSERT''
OR :dml.get_command_type() = ''DELETE'')
AND :dml.get_object_owner() = ''RT01''
AND :dml.get_object_name() = ''ORDERPDO_ORDER'' ');
end;
/
begin
dbms_streams_adm.add_table_rules(
table_name =>'server7.bizdoc',
streams_type =>'capture',
streams_name =>'capture_prod',
queue_name =>'strmadmin.prod_queue',
include_dml =>true,
include_ddl =>true,
include_tagged_lcr =>false,
source_database =>null,
inclusion_rule =>true,
and_condition =>':lcr.get_command_type() in (''INSERT'',''UPDATE'')');
end;
/
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/35489/viewspace-630428/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ORACLE10g Stream表級複製配置Oracle
- Oracle10g新特性之stream流配置Oracle
- ORACLE10g Stream使用者級複製配置Oracle
- Java-stream(1) Stream基本概念 & Stream介面Java
- stream
- 使用dataX-stream2stream/stream2mysql/mysql2mysql/mysql2streamMySql
- Java StreamJava
- Stream APIAPI
- elysia stream
- Stream流
- Stream 流模組
- Java 8 StreamJava
- ORACLE STREAM ERROROracleError
- restart oracle streamRESTOracle
- Java Lambda StreamJava
- [Java]Stream用法Java
- spark stream初探Spark
- Oracle simple streamOracle
- Stream瞭解
- centos stream 8CentOS
- 聊聊 Redis StreamRedis
- Stream流求和
- Java Stream 詳解Java
- Java Stream流使用Java
- Stream聚合函式函式
- 【java】Stream的使用Java
- nodeJS之流streamNodeJS
- Oracle stream案例分享Oracle
- stream配置總結
- java-Stream流Java
- oracle stream pool sizeOracle
- spel和stream todo
- stream流各種
- [Javascript] Refactor blocking style code to stream style for fetching the stream dataJavaScriptBloC
- Java8 Lambda表示式與Stream API (二): Stream API的使用JavaAPI
- 在 Flutter 裡使用 StreamFlutter
- Java8——Stream流Java
- Node.js Stream(流)Node.js