Project:
| View Revisions: Issue #44612 | [ All Revisions ] [ Back to Issue ] | ||
| Summary | 0044612: ORA fails applying changes to columns used in functional indexes | ||
| Revision | 2020-08-07 12:18 by alostale | ||
| Description | When updating an Oracle database having changes in a column that participates in a functional index, Oracle fails and the change is not applied. This can occur by either a config script providing those changes or by a regular DB change. In case a template modifies an indexed column oracle fails on compilation: SQL Command failed with: ORA-30556: either functional or bitmap join index is defined on the column to be modified |
||
| Revision | 2020-08-07 09:24 by alostale | ||
| Description | In case a template modifies an indexed column oracle fails on compilation: SQL Command failed with: ORA-30556: either functional or bitmap join index is defined on the column to be modified Example of the config script: <vector> <versionInfo version="3.0.36908"/> <columnSizeChange tablename="AD_USER" columnname="NAME" newSize="120" oldSize="60"/> <columnSizeChange tablename="C_BPARTNER" columnname="NAME" newSize="120" oldSize="60"/> <columnDataChange tablename="AD_COLUMN" columnname="FIELDLENGTH" pkRow="213"> <oldValue><![CDATA[60]]></oldValue> <newValue><![CDATA[120]]></newValue> </columnDataChange> <columnDataChange tablename="AD_COLUMN" columnname="FIELDLENGTH" pkRow="2902"> <oldValue><![CDATA[60]]></oldValue> <newValue><![CDATA[120]]></newValue> </columnDataChange> <columnDataChange tablename="AD_FIELD" columnname="DISPLAYLENGTH" pkRow="300"> <oldValue><![CDATA[60]]></oldValue> <newValue><![CDATA[120]]></newValue> </columnDataChange> <columnDataChange tablename="AD_FIELD" columnname="DISPLAYLENGTH" pkRow="2145"> <oldValue><![CDATA[60]]></oldValue> <newValue><![CDATA[120]]></newValue> </columnDataChange> </vector> |
||
| Copyright © 2000 - 2009 MantisBT Group |
 |