Details
-
Suggestion
-
Resolution: Unresolved
-
None
-
None
-
4
-
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