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

Thread: Multimaster Replication

  1. #1
    Join Date
    Feb 2001

    Question Multimaster Replication

    Oracle 9.2.0

    Master = DB1
    Replicated database = DB2

    I'm planning on setting up multimaster replication to offload a heavily queried schema (which is also updated through triggers) to another Oracle Server Box.

    My question is, can I delete rows from the master (DB1) without those deletions being propagated to the replicated database (DB2)

    The rational behind this is to keep the DB1 database as small as possible to improve performance while querying on the much larger database DB2.

    The logistics of this have been worked out and no application conflicts will occur.

    What I wanted to know is - is this possible.

    Many thanks in advance for your help.

    What's the sound of one hand clapping - "CL"

  2. #2
    Join Date
    Mar 2000
    Atlanta, GA,USA
    RTFM over here:

    Sergey Popov
    BA Merchant Services
    Louisville, KY

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