1 Reply Latest reply: Jan 26, 2013 10:10 AM by stevencallan RSS

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

    AMSI
      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
          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).