Database Software

Hi, can anyone tell me why the create_capture call below (for local capture test) 1) tries to execute ALTER DATABASE ADD SUPPLEMENTAL LOG DATA and 2) hangs when it does?

To be honest, I am more concerned that it is being run at all. I thought that adding supplemental logging was a manual task? I do not want this configured for the entire database. Perhaps I have incorrectly specified a parameter? I have shown the rule set as well, in case that is relevant.

any help is sincerely appreciated, thanks in advance.

begin
dbms_rule_adm.create_rule(
rule_name => 'DLM$TEST_TABLE$001'
,condition => ':dml.get_source_database_name() = ''DLMPOC01.WORLD'' and :dml.get_object_owner() = ''DLM'' and :dml.get_object_name() = ''TEST_TABLE'' a
nd :dml.is_null_tag() = ''Y'''
,evaluation_context => NULL
,action_context => NULL
,rule_comment => 'capture TEST_TABLE changes');
dbms_rule_adm.create_rule_set(
rule_set_name => 'CAPTURE_TEST_RULE_SET'
,evaluation_context => 'SYS.STREAMS$_EVALUATION_CONTEXT'
,rule_set_comment => 'capture rules for test');
dbms_rule_adm.add_rule(
rule_name => 'DLM$TEST_TABLE$001'
,rule_set_name => 'CAPTURE_TEST_RULE_SET'
,evaluation_context => NULL
,rule_comment => NULL);
end;
/

15:15:40 SQL> BEGIN
15:15:40 2 DBMS_CAPTURE_ADM.CREATE_CAPTURE(
15:15:40 3 queue_name => 'STREAMS.TEST_QUEUE'
15:15:40 4 ,capture_name => 'TEST_CAPTURE'
15:15:40 5 ,rule_set_name => 'STREAMS.CAPTURE_TEST_RULE_SET'
15:15:40 6 ,start_scn => NULL
15:15:40 7 ,source_database => NULL
15:15:40 8 ,use_database_link => FALSE
15:15:40 9 ,first_scn => NULL
15:15:40 10 ,logfile_assignment => 'implicit'
15:15:40 11 ,capture_user => NULL
15:15:40 12 ,checkpoint_retention_time => 0.25); -- days
15:15:40 13 END;
15:15:40 14 /