Uploaded image for project: 'Bitbucket Data Center'
  1. Bitbucket Data Center
  2. BSERV-3385

Enable Oracle Golden Gate replication

    XMLWordPrintable

Details

    • 7
    • We collect Bitbucket feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

    Description

      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.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              4e6234523fbc Sabre DOS
              Votes:
              7 Vote for this issue
              Watchers:
              12 Start watching this issue

              Dates

                Created:
                Updated: