Home » Server Options » Streams & AQ » Blob data type Streams replication (oracle 10g,release 2, windows 2003 server)
Blob data type Streams replication [message #405008] Tue, 26 May 2009 01:14 Go to next message
mirasraf
Messages: 52
Registered: June 2006
Location: DHAKA
Member

Hi
Thanks ,
I set up streams configuraion . Everything is ok,But I face some problem BLOB data type replication.

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
Asraf
Re: Blob data type Streams replication [message #405247 is a reply to message #405008] Wed, 27 May 2009 03:01 Go to previous message
mirasraf
Messages: 52
Registered: June 2006
Location: DHAKA
Member

hi,

How Can I replicate BLOB data type in streams.

Phase 1:
When I use procedure "add_subset_propagation_rules " to replicate BLOB data then script would not execute.

connect strmadmin/strmadmin@ps
begin
dbms_streams_adm.add_subset_propagation_rules (
table_name => 'datatest.adm_person',
dml_condition => 'IS_EMPLOYEE=''YES''',
streams_name => 'propa_ps_ds',
source_queue_name => 'capture_ps',
destination_queue_name => 'apply_ds@ds',
source_database => 'ps',
include_tagged_lcr =>false);
end;
/

this script could not execute ,generate an error

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

Phase 2:
But When I replicate table level then script execute

conn strmadmin/strmadmin@ps
BEGIN
DBMS_STREAMS_ADM.ADD_TABLE_PROPAGATION_RULES(
table_name =>'datatest.adm_person',
streams_name =>'propa_ps_ds',
source_queue_name =>'capture_ps',
destination_queue_name =>'apply_ds@ds',
include_dml =>true,
include_ddl =>false,
source_database =>'ps');
END;
/

ok.


please give me the way ,how to replicate BLOB Data Type.

Best Regards
Asraf
Previous Topic: Trying to use streams to replicate tables on same machine
Next Topic: AQ or replication
Goto Forum:
  


Current Time: Thu Mar 28 08:10:18 CDT 2024