Function-based Index

From: fumi <fumi_at_tpts5.seed.net.tw>
Date: 15 Aug 1999 16:45:14 GMT
Message-ID: <7p6qqq$88m$1@news.seed.net.tw>

Hi,

Oracle 8i supports the function-based indexes. I have consulted the SQL Reference, and Tunning manual, and set the "QUERY_REWRITE_ENABLED" parameter to be TRUE.

I tried it using a account with DBA role privilege, it works. But when I tried it using the default "scott" account, I got a error message "ORA-01031: insufficient privileges" (see the following). Does anyone know which privilege is lack for scott account to create a function-based index?

SQL> create table test (
  2 a number,
  3 b number);

Table created.

SQL> create index ind_test on test (a+b); create index ind_test on test (a+b)

                                 *

ERROR at line 1:
ORA-01031: insufficient privileges Received on Sun Aug 15 1999 - 11:45:14 CDT