Re: function based indexes

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Fri, 15 Nov 2002 07:41:16 +0100
Message-ID: <vm59tus73ttobn1bip5qjap6p8h9orjk91@4ax.com>

On 14 Nov 2002 18:02:53 -0800, kumar_kmk_at_hotmail.com (Kumar) wrote:

>Hi
>I am trying to create a function based index and getting
>ORA-00439 : feature not enabled function based indexes.
>
>I looked in v$option table and i find the parameter "function based
>indexes" with value false.
>
>Question: how do i make it true (to enable fn based index)
>
>I tried like this:
>" update v$option set value ='true' where parameter like
>'Function-based indexes'
>I got an error saying can only select from fixed tables/views
>
>Thanks for any responses
>
>kumar

just buy or download the Enterprise Edition. You must be using Standard

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri Nov 15 2002 - 00:41:16 CST