ORA-30554: function-based index string.string is disabled



ORA-30554: function-based index string.string is disabled..

Answer / guest

Cause: An attempt was made to access a function-based index
that has been marked disabled because the function on which
the index depends has been changed.

Action: Perform one of the following actions: -- drop the
specified index using the DROP INDEX command -- rebuild the
specified index using the ALTER INDEX REBUILD command --
enable the specified index using the ALTER INDEX ENABLE
command -- make the specified index usable using the ALTER
INDEX UNUSABLE command

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-31077: invalid attribute "string" specified

1 Answers  


TNS-00135: Missing TNS error message file

1 Answers  


QSM-01124: set operator materialized view, string, doesn't have a marker column

1 Answers  


ORA-02808: Allocation of memory of open files array failed.

1 Answers  


ORA-16123: transaction string string string is waiting for commit approval

1 Answers  


DRG-11127: inconsistent index policy with trained rule

1 Answers  


ORA-23491: no valid extension request at "string"

1 Answers  


ORA-27543: Failed to cancel outstanding IPC request

1 Answers  


PLS-00528: The parameters to an ORDER function must have IN mode

1 Answers  


PCC-02334: SQL identifier was not declared as a cursor

1 Answers  


ORA-13617: The specified task string already executing

1 Answers  


UDE-00006: failed to allocate memory of size number

1 Answers  


Categories