This discussion is archived
1 Reply Latest reply: Jan 26, 2013 8:10 AM by stevencallan RSS

Can we replicat the tables that have No constraint???

AMSI Newbie
Currently Being Moderated
hi,

I just want to know that can Golden gate support the replication of those tables that have No constraints.... if we can do then wht are thier extract or datapump paramters.

Regards
AMSII
  • 1. Re: Can we replicat the tables that have No constraint???
    stevencallan Expert
    Currently Being Moderated
    GoldenGate has a hierarchy of what it looks for (PK, unique) and "worst case" is using all columns. Short of that, you can specify KEYCOLS (key columns, enough columns to help uniquely identify a record). If you are going without constraints (which is another topic altogether and goes against pretty much all design practices in major RDBMSs), be prepared to deal with 1403 errors (i.e., add exception handling).

Legend

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