Enable Oracle Golden Gate replication

XMLWordPrintable

    • 8
    • 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: