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-29260: network error: string

1 Answers  


ORA-29391: %s and string must be mandatory to create a mandatory plan directive

1 Answers  


ORA-13139: could not obtain column definition for string

1 Answers  


ORA-14007: missing LESS keyword

1 Answers  


ORA-21606: can not free this object

1 Answers  






ORA-06722: TLI Driver: connection setup failure

1 Answers  


ORA-38417: attribute set string does not exist

1 Answers  


ORA-24130: table string does not exist

1 Answers  


ORA-13830: SQL profile with category string already exists for this SQL statement

1 Answers  


QSM-01126: query rewritten with set operator materialized view, string

1 Answers  


LSX-00143: element "~S" must have type or ref

1 Answers  


ORA-31515: CDC change source string already exists

1 Answers  


Categories