| Blob data type Streams replication [message #405008] |
Tue, 26 May 2009 01:14  |
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  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
