Showing posts with label ORA-30556: functional index is defined on the column to be modified. Show all posts
Showing posts with label ORA-30556: functional index is defined on the column to be modified. Show all posts

Wednesday, 23 May 2012

ORA-30556: functional index is defined on the column to be modified

ORA-30556: functional index is defined on the column to be modified

Cause: An ALTER TABLE MODIFY COLUMN was issued on a column on which a functional index exists.

Action: Drop the functional index before attempting to modify the column.