Database Error Messages

An attempt was made to modify the declared collation of a column that either: o belonged to a foreign key o belonged to a primary or unique key and that key was referenced by some foreign key o corresponded to a cluster key column o was referenced by a defining expression of a virtual column o was referenced by a defining expression of a functional index o corresponded to an attribute of a user-defined type or an object table o belonged to the container table of a materialized view o was referenced by a join condition of a bitmap join index The declared collation of such columns cannot be modified.

Use one of the following as appropriate: o Drop the offending constraint, virtual column, or index, modify the collation of the column, and re-create the dropped element. o If possible, modify the type attribute instead of the column. o If possible, modify the derived collation of the corresponding materialized view column (for example, with the COLLATE operator) and re-create the materialized view to re-create its container table with the new column collation. o Save the tables of a cluster, re-create the cluster using the new collation, and restore the saved tables into the cluster.

An attempt was made to modify the declared collation of a column that either: o belonged to a foreign key o belonged to a primary or unique key and that key was referenced by some foreign key o corresponded to a cluster key column o was referenced by a defining expression of a virtual column o was referenced by a defining expression of a functional index o corresponded to an attribute of a user-defined type or an object table o belonged to the container table of a materialized view o was referenced by a join condition of a bitmap join index The declared collation of such columns cannot be modified.

Use one of the following as appropriate: o Drop the offending constraint, virtual column, or index, modify the collation of the column, and re-create the dropped element. o If possible, modify the type attribute instead of the column. o If possible, modify the derived collation of the corresponding materialized view column (for example, with the COLLATE operator) and re-create the materialized view to re-create its container table with the new column collation. o Save the tables of a cluster, re-create the cluster using the new collation, and restore the saved tables into the cluster.

An attempt was made to modify the declared collation of a column that either: o belonged to a foreign key o belonged to a primary or unique key and that key was referenced by some foreign key o corresponded to a cluster key column o was referenced by a defining expression of a virtual column o was referenced by a defining expression of a functional index o corresponded to an attribute of a user-defined type or an object table o belonged to the container table of a materialized view o was referenced by a join condition of a bitmap join index The declared collation of such columns cannot be modified.

Use one of the following as appropriate: o Drop the offending constraint, virtual column, or index, modify the collation of the column, and re-create the dropped element. o If possible, modify the type attribute instead of the column. o If possible, modify the derived collation of the corresponding materialized view column (for example, with the COLLATE operator) and re-create the materialized view to re-create its container table with the new column collation. o Save the tables of a cluster, re-create the cluster using the new collation, and restore the saved tables into the cluster.