| function-based index disabled [message #77] |
Fri, 11 January 2002 00:48  |
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 #81 is a reply to message #79] |
Fri, 11 January 2002 04:06  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
