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-00319: log string of thread string has incorrect log reset status

1 Answers  


ORA-07706: error in archive text: need disk file name

1 Answers  


ORA-32818: AQ queue string does not exist

1 Answers  


ORA-14406: updated partition key is beyond highest legal partition key

1 Answers  


RMAN-03011: Recovery Manager: Release string string

1 Answers  






NNF-04004: Invalid string in inputfile

1 Answers  


ORA-08265: create_ora_addr: cannot open nameserver

1 Answers  


ORA-36881: (XSSRF00) The OLAP DML ROW2CELL function can only be used in a LIMITMAP.

1 Answers  


ORA-13858: Invalid action name

1 Answers  


TNS-00122: Missing ADDRESS(es) in TNSNET.ORA file

1 Answers  


ORA-12215: TNS:poorly formed PREFERRED_NAVIGATORS Addresses in TNSNAV.ORA

1 Answers  


ORA-24098: invalid value string for string

1 Answers  


Categories