Blob data type Streams replication
647561May 26 2009 — edited Jun 2 2010Hi
Thanks ,
I set up streams configuraion . Everything is ok,But I face some problem BLOB data type replication.(Oracle 10g Rel-2,Windows 2003 Server)
My database schema have about 300 tables. One table that carry BLOB data (image),I want this table will replicate conditional.
But I cound not do it.
Example:
This table contain two BLOB Data Type Column. and one column is
"IS_REPLICATE" . When column("IS_REPLICATE") value "YES" then this row will be replicate.
Rule:
connect ***/**@**
begin
dbms_streams_adm.add_subset_propagation_rules (
table_name => 'datatest.person',
dml_condition => 'IS_REPLICATE=''YES''',
streams_name => 'propa_ps_ds',
source_queue_name => 'capture_ps',
destination_queue_name => 'apply_ds@**,
source_database => '**',
include_tagged_lcr =>false);
end;
/
Error Message
begin
*
ERROR at line 1:
ORA-23605: invalid value "datatest.person" for STREAMS parameter TABLE_NAME
ORA-06512: at "SYS.DBMS_LOGREP_UTIL", line 80
ORA-06512: at "SYS.DBMS_LOGREP_UTIL", line 123
ORA-06512: at "SYS.DBMS_STREAMS_ADM_UTL", line 3247
ORA-06512: at "SYS.DBMS_STREAMS_ADM", line 1422
ORA-06512: at "SYS.DBMS_STREAMS_ADM", line 1320
ORA-06512: at line 2
But When I replicate whole table than OK(No condition).
Regards
Foreign