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



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

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-16774: Error in stopping the physical apply service (MRP process)

1 Answers  


ORA-28503: bind value cannot be translated into SQL text for non-Oracle system

1 Answers  


TNS-01160: Trace level was not specified

1 Answers  


ORA-29956: warning in the execution of ODCIINDEXEXCHANGEPARTITION routine

1 Answers  


PCC-00098: Scale specification cannot be used in this context

1 Answers  






TNS-00025: INTCTL: The ORACLE environment is not set up correctly

1 Answers  


IMG-00870: unsupported aspect ratio or image size

1 Answers  


ORA-00711: new tablespace name is invalid

1 Answers  


ORA-15113: alias name 'string' refers to a directory

1 Answers  


ORA-30488: argument should be a function of expressions in PARTITION BY

1 Answers  


ORA-02396: exceeded maximum idle time, please connect again

1 Answers  


CLSR-06501: Exceeds maximum number of arguments

1 Answers  


Categories