Press "Enter" to skip to content

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;

Oracle Streams