This discussion is archived
2 Replies Latest reply: Feb 4, 2013 2:01 PM by Nick_W RSS

wht is paramter for Replicat if the tables have no unique record

AMSI Newbie
Currently Being Moderated
hi,
I have some tables in Source . i just want to replicat it. but cant do that. So wht is the parameter that can handle such type of replication of all the tables that have no primary key or Unique key.

???

Regards,
AMSII
  • 1. Re: wht is paramter for Replicat if the tables have no unique record
    satrap Journeyer
    Currently Being Moderated
    Use APPLYNOOPUPDATES to force the update to be applied using all columns in both the SET and WHERE clause
  • 2. Re: wht is paramter for Replicat if the tables have no unique record
    Nick_W Explorer
    Currently Being Moderated
    OGG can usually handle this automatically. If you look at the report file, it will say that the table does not have a key that can be used and instead it's using all available columns in the where clause. So this means that any non-LOB type column will be used in the WHERE clause that is constructed to update or delete records.

    data types that cannot be used in the where clause will automatically be excluded, like CLOB, BLOB, NCLOB, nested tables, UDTs, VARRAYs, etc.. .

    Also, it will ensure that only one row is updated at a time (see the LIMITROWS parameter for more details on this as it only applies to certain databases.)

    And, if you know that a table may not have a unique key or primary key, but one column is unique, then you can use KEYCOLS to override the default behavior and force a certain column to be used as the key. Keep in mind that this column must be in the trail file for replicat to use in the where clause, so you'll need to ensure that it is brought over from Extract.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points