streams erplication scenario
edited Apr 19, 2013 8:54PM in GoldenGate, Streams and Distributed Database (MOSC) 6 commentsAnswered
SQL> SQL> beginDBMS_STREAMS_ADM.DELETE_COLUMN(
rule_name => 'STRMADMIN.DECL', -- DML Apply rule for EBC_TEST.ADDR_TEST
table_name => 'EBC_TEST.ADDR_TEST',
column_name => 'CATEGORY',
operation => 'ADD');
end;
/
2 3 4 5 6 7 8
begin
*
ERROR at line 1:
ORA-23605: invalid value "STRMADMIN.DECL" for STREAMS parameter RULE_NAME
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.DBMS_LOGREP_UTIL", line 280
ORA-01403: no data found
ORA-06512: at "SYS.DBMS_STREAMS_ADM", line 3558
ORA-06512: at line 2
rule_name => 'STRMADMIN.DECL', -- DML Apply rule for EBC_TEST.ADDR_TEST
table_name => 'EBC_TEST.ADDR_TEST',
column_name => 'CATEGORY',
operation => 'ADD');
end;
/
2 3 4 5 6 7 8
begin
*
ERROR at line 1:
ORA-23605: invalid value "STRMADMIN.DECL" for STREAMS parameter RULE_NAME
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.DBMS_LOGREP_UTIL", line 280
ORA-01403: no data found
ORA-06512: at "SYS.DBMS_STREAMS_ADM", line 3558
ORA-06512: at line 2
0