Replication
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Replication

  1. #1
    Join Date
    Dec 1999
    Location
    Alpharetta, GA, US
    Posts
    192

    Thumbs down

    i would like to know what type of replication better deal with my application. i got OLTP database on 8.1.6 (ORA1) and application (APP1), i will receive the data from the real-time, i will process the data and insert into the table's.
    I got another application (ORA2)and applicatoin (APP2) which is going to use only one table from my OLTP database ( ONLY SELECTS approximately 400 transactions/second).
    My question is can i replicate only one table from my ORA1 database on to ORA2 database? so that my APP2 application will select the data from the database ORA2. If it is correct,
    what kind of replication methode i have to follow.


    Thanks

  2. #2
    Join Date
    Sep 2002
    Posts
    42
    In your case simple replications is enough

    1)Simply create a dblink from ORA2---> ORA1
    in a schema where table is needed

    2)Create a snapshot log in ORA1 using primary key

    3) Create a snapshot in ORA2 in the same schema where db_link is created and table is needed

    If you do this far(are all the records from ORA1 to ORA2
    replicated just after creating a snapshot,then let us know

    I'll give you further help if you re thru with the above steps

    Cheers
    In GOD I find everything

  3. #3
    Join Date
    Dec 1999
    Location
    Alpharetta, GA, US
    Posts
    192
    Thanks for your reply.

  4. #4
    Join Date
    Dec 1999
    Location
    Alpharetta, GA, US
    Posts
    192
    what is the difference between Snapshot Replication and Materialized View Replication ?

    Thanks

  5. #5
    Join Date
    Sep 2002
    Posts
    42
    before 8.1.6 they call it snapshot

    from 8.1.6 onwards we call it materialized view or a snapshot

    Materialized view is superset of snapshot+properties of view

    check with Documentation

    view + material = Materialized view

    GOOD LUCK
    In GOD I find everything

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