Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Blob data type Streams replication

647561May 26 2009 — edited Jun 2 2010
Hi
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

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 30 2010
Added on May 26 2009
9 comments
5,175 views