Function based index problem

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 - 13:27:57 CST