Home » SQL & PL/SQL » SQL & PL/SQL » function-based index disabled
function-based index disabled [message #77] Fri, 11 January 2002 00:48 Go to next message
Monika Schraepel
Messages: 2
Registered: January 2002
Junior Member
What can cause a function-based index to become disabled?

In development everyting worked fine but when trying to use it in an applikation-test the index failed.

ORA-30554: function-based index my_index disabled

I found:
status = valid
funcidx_status = disabled

my_index refferes to a user-function, but the package wich contains this function wasn't touched after creation of the index.

Any idea on what caused the index to become disabled?
I would greatly appreciate any help!

Monika
Re: function-based index disabled [message #79 is a reply to message #77] Fri, 11 January 2002 03:46 Go to previous messageGo to next message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
Hi,

1. is the package is valid ? (see dba_objects /user_objects).
2. try one of these
dropping and recreating index
or ALTER INDEX REBUILD
or ALTER INDEX enable

cheers
pratap
Re: function-based index disabled [message #81 is a reply to message #79] Fri, 11 January 2002 04:06 Go to previous message
Monika Schraepel
Messages: 2
Registered: January 2002
Junior Member
Hi,

thanks a lot for your reply.

>ALTER INDEX enable
this of course works fine.

My problem is, i couldn't predict the index becoming invalid because i didn't do anything to invalidate it.

The package was valid.

I haven't used a function-based index before.
I found it very useful but i need to be sure it works before using it in an applikation.

I've read somewhere in a posting they have some issues and 'tend to go invalid' especially for large tables.

Has anyone ever encountered an error like this in a similar situation? Can anything other than an invalid package cause a function-based index to become invalid?

thanks again to everyone trying to help me solve this problem

monika
Previous Topic: Please help with converting SQL
Next Topic: FOR???
Goto Forum:
  


Current Time: Thu Jun 21 17:30:56 CDT 2018