Excluding Unsupported Tables To Be Captured By Oracle Streams
After capture process creation edit and run below PLSQL block to ignore tables to be captured which are unsupported.
DECLARE
CURSOR VIN Is
Select TABLE_NAME
From DBA_STREAMS_UNSUPPORTED
Where OWNER = ‘URSCHEMA’;
BEGIN
For C In VIN LOOP
dbms_streams_adm.add_table_rules (
table_name => ‘URSCHEMA.’||C.TABLE_NAME,
streams_type => ‘capture’,
streams_name => ‘STREAMS_CAPTURE’,
queue_name => ‘STRMADMIN.STREAMS_CAPTURE_Q’,
include_dml => true,
include_ddl => false,
inclusion_rule => false,
source_database => ‘STREAM’
);
END LOOP;
COMMIT;
