Enable Oracle Golden Gate replication

XMLWordPrintable

    • 7
    • 6

      In our company we use Golden Gate to replicate databases. Our DBAs found following issues which prevent Golden Gate from replicating schema used by Stash:

      1. Indexes and constraints with system generated names are not supported

      CONSTRAINT_TYPE TABLE_NAME
      ------------------------------- ------------------------------
      P AO_CFE8FA_BUILD_STATUS
      P AO_FB71B4_PUBLIC_KEY
      P AO_6978BB_RESTRICTED_REF
      P AO_6978BB_PERMITTED_ENTITY
      U WEIGHTED_PERMISSION
      P PLUGIN_SETTING

      P - Primary Key
      U - Unique Key

      Solution: Primary/Unique keys and indexes assigned to them should be named

      2. Tables With No Primary Key or Unique Index
      Table Rows
      ------------------------ --------
      CS_ATTRIBUTE 906
      HIBERNATE_UNIQUE_KEY 1
      HT_STA_PR_ACTIVITY
      ID_SEQUENCE 14

      Solution: Primary or Unique keys should be created for those tables.

              Assignee:
              Unassigned
              Reporter:
              Sabre DOS
              Votes:
              8 Vote for this issue
              Watchers:
              13 Start watching this issue

                Created:
                Updated: