| 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?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
