who have an example of apply forwarding?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: who have an example of apply forwarding?

  1. #1
    Join Date
    Aug 2006
    Posts
    26

    who have an example of apply forwarding?

    see title.

    who have an complete example of apply forwarding?


    thanks.

  2. #2
    Join Date
    Aug 2006
    Posts
    26
    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.

    who do it?

  3. #3
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    you seem to have an aversion to supplying any details or doing any research of your own

  4. #4
    Join Date
    Aug 2006
    Posts
    26
    hi.
    you are right.
    my english is not very good.

  5. #5
    Join Date
    Aug 2006
    Posts
    26
    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.

  6. #6
    Join Date
    Aug 2006
    Posts
    26

    source script

    see Attachment:
    Attached Files Attached Files

  7. #7
    Join Date
    Aug 2006
    Posts
    26

    the source script

    set attachment
    Attached Files Attached Files

  8. #8
    Join Date
    Aug 2006
    Posts
    26

    the result of test

    1.insert value in orc0,the result is the data is replicated at the orc1 and orc2

    SQL> connect strmadm/strmadm@orc0;
    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);

    1 row inserted

    SQL> Select * From strmusr.product@Orc2.net;

    ID NAME DESCRIPTION PRICE
    --------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ----------
    1 ZLSOFT2 zlsoft software 800000.00

    SQL> Select * From strmusr.product@Orc1.net;

    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);

    1 row inserted

    SQL> commit;

    Commit complete

    SQL> Select * From strmusr.product@Orc2.net;

    ID NAME DESCRIPTION PRICE
    --------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ----------
    1 ZLSOFT2 zlsoft software 800000.00

    SQL> Select * From strmusr.product@Orc1.net;

    ID NAME DESCRIPTION PRICE
    --------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ----------
    1 ZLSOFT2 zlsoft software 800000.00
    2 ZLSOFT2 zlsoft software 800000.00

    SQL> Select * From strmusr.product@Orc0.net;

    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);

    1 row inserted

    SQL> commit;

    Commit complete

    SQL> Select * From strmusr.product@Orc0.net;

    ID NAME DESCRIPTION PRICE
    --------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ----------
    3 ZLSOFT2 zlsoft software 800000.00
    2 ZLSOFT2 zlsoft software 800000.00
    1 ZLSOFT2 zlsoft software 800000.00

    SQL> connect strmadm/strmadm@orc2;
    Connected to Oracle Database 10g Enterprise Edition Release 10.2.0.1.0
    Connected as strmadm

    SQL> Select * From strmusr.product@Orc1.net;

    ID NAME DESCRIPTION PRICE
    --------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ----------
    1 ZLSOFT2 zlsoft software 800000.00
    2 ZLSOFT2 zlsoft software 800000.00


    SQL> Select * From strmusr.product@Orc2.net;

    ID NAME DESCRIPTION PRICE
    --------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ----------
    1 ZLSOFT2 zlsoft software 800000.00
    3 ZLSOFT2 zlsoft software 800000.00

    SQL>

  9. #9
    Join Date
    Aug 2006
    Posts
    26
    davey23uk
    can you help me at the problem?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width