You don't give an error message, but function based indexes are available
only in the enterprise edition in versions before 9.
<1443131_at_usenetplanet.com> wrote in message
news:3c76945d.330773106_at_64.154.60.165...
>
> We have two different databases. In both database, following works:
>
> create index idx1 on tab1(c1);
>
> However, following function based index creation works in one
> database, but not in the other:
>
> create index idx1 on tab1(substr(c1,1,2));
>
> I checked privileges in both databases and could not find any that is
> assigned in one but not the other. Why is it working in one database
> while it does not in the other? Database versions are the same.
> Thank you in advance.
>
>
>
>
Received on Fri Feb 22 2002 - 14:26:33 CST
