Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Location
    Jordan
    Posts
    137

    Lightbulb Unanswered: Replication Tips

    Hi,
    We are going to implement Oracle Advanced Replication, are there any ideas, notes, take care points, that i need to consider before starting this implementation or during implementation, i don't want to be surprized in the mid, cause my experience in this subject not that much...

    thanx
    Giggs

  2. #2
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Ensure you have set any triggers to know that the trx's are from replication and not from the application... You don't want them to fire again upon replication....

    if dbms_reputil.from_remote() OR DBMS_SNAPSHOT.I_AM_A_REFRESH()
    then
    return;
    end if;

    Also set you RI constraints to deferred (foreign keys) ...

    Conflict resolution should also be setup ...
    Sequences are not replicatable items, so if you are using anything like sequences or max(id)+1, you need to rethink that logic...

    Just a few items ...
    HTH
    Gregg

Posting Permissions

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