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-12570: TNS:packet reader failure

1 Answers  


ORA-07415: slpath: allocation of memory buffer failed.

1 Answers  


ORA-16045: circular archive log destination dependency chain

1 Answers  


QSM-01123: self-join algorithm could not resolve multiple instances

1 Answers  


ORA-00093: %s must be between string and string

1 Answers  






ORA-12480: specified clearance labels not within the effective clearance

1 Answers  


ORA-32141: get method does not match the type of the parameter

1 Answers  


TNS-00044: INTCTL: You must have an INTCHG.ORA file to contact the Connection Manager

1 Answers  


ORA-30351: query rewrite does not currently support this expression

1 Answers  


DRG-12219: section name missing

1 Answers  


IMG-02006: 2FF06 - average color feature cannot be determined

1 Answers  


ORA-16219: This database is not preparing to switch over.

1 Answers  


Categories