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

Support Oracle RDBMS with Extended Statistics enabled

XMLWordPrintable

    • 5
    • 4
    • 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.

      Problem Definition

      When upgrading to Bitbucket 4.2 or greater, one of the database operations involves renaming a column. Oracle DB's have a feature called Extended Statistics which creates virtual columns based on regular columns, and this feature, if enabled, will prevent the DB upgrade from renaming regular columns that are used in virtual columns.

      Workaround

      Users can manually disable extended statistics or drop virtual columns themselves, then proceed with the upgrade, as per Database Upgrade Error: column to be renamed is used in a virtual column expression

      Suggested Solution

      Wrap schema updates with logic to drop/create extended statistics / virtual columns. More info can be found in ORA-54033 and the Hidden Virtual Column Mystery

              Unassigned Unassigned
              dchevell Dave Chevell
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Created:
                Updated:
                Resolved: