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

DRG-11620: URL store: thread operation error

1 Answers  


ORA-27210: syntax error in device PARMS

1 Answers  


ORA-29844: duplicate operator name specified

1 Answers  


O2I-00123: Unable to close the INITFILE file

1 Answers  


ORA-04092: cannot string in a trigger

1 Answers  


LRM-00109: could not open parameter file 'string'

1 Answers  


ORA-19624: operation failed, retry possible

2 Answers  


ORA-16104: invalid Logical Standby option requested

1 Answers  


ORA-02098: error parsing index-table reference (:I)

1 Answers  


SQL*Loader-00467: attribute string does not exist in type string for table string.

1 Answers  


ORA-16052: DB_UNIQUE_NAME attribute is required

1 Answers  


ORA-01219: database not open: queries allowed on fixed tables/views only

1 Answers  


Categories