Home » Server Options » Streams & AQ » Add_Subset_propagation_rules for BLOB data type (Oracle 10g,rel-2. Windows 2003 Server)
icon5.gif  Add_Subset_propagation_rules for BLOB data type [message #407375] Wed, 10 June 2009 00:11
Messages: 52
Registered: June 2006
Location: DHAKA

Dear friend,

Is there any way to add subset of a table with BLOB column to streams with add_subset_propagation_rules ?

I configure streams replication. I have a table(Test) that contain 2 BLOB data type column.Can I use
procedure to subset data replication this table(Test) ?

Suppose Table(test) structure:
(id number,
name varchar2(100),
Picure blob,
signature blob,
is_replicate varchar2(3)

conn strmadmin/strmadmin@ps

dbms_streams_adm.add_subset_propagation_rules (
table_name => 'scott.test',
dml_condition => 'is_replicate=''yes''',
streams_name => 'propa_ps_ds',
source_queue_name => 'capture_ps',
destination_queue_name => 'apply_ds@ds',
source_database => 'ps',
include_tagged_lcr =>false);

But I got error

can anybody help what is the way to replicate data for BLOB contain table?

Best Regards
Previous Topic: Message Text: ORA-01003: no statement parsed
Next Topic: Table not in sync in bi-directional streams replication
Goto Forum:

Current Time: Fri Oct 28 02:05:57 CDT 2016

Total time taken to generate the page: 0.15833 seconds