Primary Database Sharing Data with Several Secondary Databases by stream is the example,but i encounter the error. primary database does not replicate to other secondary database,and does not error display.
now ,the result is primary database can replicate to other secondary database,but secondary database is replicated only to primary database,not forwarded to other secondary database.
ID NAME DESCRIPTION PRICE
--------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ----------
1 ZLSOFT2 zlsoft software 800000.00
2.insert value in orc1,the result is the data is replicated at the orc0,but is not at the orc2
SQL> connect strmadm/strmadm@orc1;
Connected to Oracle Database 10g Enterprise Edition Release 10.2.0.1.0
Connected as strmadm
SQL> Insert Into strmusr.product(Id,Name,description,price) Values(strmusr.product_id.Nextval,'ZLSOFT2','zlsoft software',800000);
ID NAME DESCRIPTION PRICE
--------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ----------
2 ZLSOFT2 zlsoft software 800000.00
1 ZLSOFT2 zlsoft software 800000.00
3.insert value in orc2,the result is the data is replicated at the orc0,but is not at the orc1
SQL> connect strmadm/strmadm@orc2;
Connected to Oracle Database 10g Enterprise Edition Release 10.2.0.1.0
Connected as strmadm
SQL> Insert Into strmusr.product(Id,Name,description,price) Values(strmusr.product_id.Nextval,'ZLSOFT2','zlsoft software',800000);