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-12086: table "string"."string" is not an object table

1 Answers  


ORA-31477: could not detach LogMiner session during cleanup

1 Answers  


ORA-09839: removeCallback: callback port is not in the callback set.

1 Answers  


ORA-25954: missing primary key or unique constraint on dimension

1 Answers  


ORA-36873: (XSTFDSC03) Column type must be specified explicitly.

1 Answers  


ORA-13136: null common code generated

1 Answers  


ORA-14402: updating partition key column would cause a partition change

2 Answers  


LPX-00202: could not open "~s" (error ~u)

1 Answers  


IMG-00543: invalid compressionFormat specified

1 Answers  


TNS-12518: TNS:listener could not hand off client connection

1 Answers  


ORA-16000: database open for read-only access

1 Answers  


TNS-00257: Number of Successful Requests : number

1 Answers  


Categories