Reg Oracle Streams Implementation..

This topic contains 1 reply, has 0 voices, and was last updated by  Amit Bansal 10 years, 7 months ago.

  • Author
    Posts
  • #1884

    Amit Bansal
    Keymaster

    –I need to create streams in a single database but between diff schema’s.

    –from schema1 to schema2 ,Then schema2 to schema3 and schema4.

    –schema1 has 500 table

    –schema2 has 500(need to replicate 150 tables)

    -schema3 has 90 tables

    –schema4 has 100 tables

    –Schema1 and Schema2 have same structure but i need to select only 150 tables out of 500 tables.

    –from schema2 to schema3 ,here also structure is same. But i need to replicate 90 tables in schema3 .

    –from schema2 to schema4 destination tables has extra columns.here iam using dml handlers.

    My ques are:

    I included DDL’s. But they are not working.

    Please give me some idea in this situation.

    Thanks,

    Ray

  • #2048

    Amit Bansal
    Keymaster

    Ray,

    I would suggest going through below link which explains filtering the tables to exclude them from replication

    http://prodlife.wordpress.com/2008/02/21/oracle-streams-replication-example/

    Cheers

    Amit

You must be logged in to reply to this topic.