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

Support Oracle RDBMS with Extended Statistics enabled

    XMLWordPrintable

Details

    • Suggestion
    • Resolution: Unresolved
    • None
    • Database - Oracle
    • None
    • 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.

    Description

      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

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated: