Re: Functional Index on Oracle in NT

I find the init param requirements are often not set by default:

QUERY_REWRITE_ENABLED=TRUE
QUERY_REWRITE_INTEGRITY=TRUSTED I wish there was some clear way to have the system tell you at index creation time that things aren't set up properly for the index to be used. (I guess it also won't be used if someone is running SE instead of EE.)

I have noticed that when using SQL*Loader, often all my rows get rejected with the error "function-based index ___ is disabled". Issuing this command fixes the problem:

ALTER INDEX ___ ENABLE; I used to think it required ALTER INDEX ___ REBUILD, since the message is supposed to happen when the function has been recompiled and I would expect the index values would need to be thrown away. But typically it is being recompiled without any changes, so maybe ENABLE vs. REBUILD doesn't matter in that case(?).

John  

On 26 Nov 2001 07:31:28 -0800, Thomas Kyte <tkyte_at_us.oracle.com> wrote:

>In article <3c023159$1_at_usenetgateway.com>, yewpc says...
>>
>>Hi , Does anyone has any ideas on function index on Oracle running
>>in NT ?

...
>yes they work in NT
>
>see
>http://asktom.oracle.com/~tkyte/article1/index.html
>
>for how to use them.

--
Got an Oracle database question?
Try the search engine for the database docs at:
http://tahiti.oracle.com/