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-38721: Invalid file number.

1 Answers  


PLS-00700: PRAGMA EXCEPTION_INIT of string must follow declaration of its exception in the same declarative part

1 Answers  


NNL-00016: cannot start server, error getting program directory's name

1 Answers  


DRG-10517: index string is already valid

1 Answers  


TNS-04003: Syntax Error.

1 Answers  


ORA-19330: Type 'string'.'string' not installed. Please install the type before using the CREATE_DBURI operator

1 Answers  


ORA-16019: cannot use string with LOG_ARCHIVE_DEST or LOG_ARCHIVE_DUPLEX_DEST

1 Answers  


ORA-01301: error writing to file during flat file build

1 Answers  


ORA-01948: identifier's name length (string) exceeds maximum (string)

1 Answers  


DRG-10753: invalid memory size string string

1 Answers  


TNS-04211: Trace Assistant Internal ERROR: CORE

1 Answers  


ORA-04082: NEW or OLD references not allowed in table level triggers

2 Answers   Satyam,


Categories