Home » RDBMS Server » Server Administration » Question about Streams subset rules
Question about Streams subset rules [message #219218] Tue, 13 February 2007 10:38
Rustican
Messages: 51
Registered: July 2006
Member
If you want to capture only a subset of table data do you first have to add table rules using the DBMS_STREAMS_ADM package then add the subset rules after?

so...

BEGIN
DBMS_STREAMS_ADM.ADD_TABLE_RULES(
table_name => 'scott.emp',
streams_type => 'capture',
streams_name => 'capture_stream',
queue_name =>
'strmadmin.streams_queue',
include_dml => true,
include_ddl => true,
inclusion_rule => true);
END;
/

then...
BEGIN
DBMS_STREAMS_ADM.ADD_SUBSET_RULES(
table_name => 'scott.emp',
dml_condition => emp_id=999',
streams_type => 'capture',
streams_name => 'capture_stream',
queue_name => 'streams_queue',
include_tagged_lcr => false,
source_database => 'mydb');
END;
/

Is this correct?
Previous Topic: Unzip
Next Topic: Migrating from 8i to 9i rel2
Goto Forum:
  


Current Time: Thu Dec 08 16:32:30 CST 2016

Total time taken to generate the page: 0.10433 seconds