Unable to create function based index on a table.

[abhijit74]

Hi Folks,

I am unable to create a function based index on a table. The error I am getting in invalid column name.
The function I am trying to use is SUBSTR(COLUMN_NAME,1,3)


I tried creating function based index for UPPER(COLUMN_NAME). It doesn't work either. I keep on getting insufficient privileges.

I used
ALTER SESSION SET QUERY_REWRITE_ENABLED = TRUE ;
to enable the option, but that doesn't seem to be working.


Cheers!
Abhijit

 

[sem]

You should be granted QUERY REWRITE.

Regards, Dima

 

[abhijit74]

Granted. Ok. I get it. It should come from some one with DBA privs. Any ideas on how to get DBA privs?

In our shop, the DBA's never listen to the developers.

Regards,
Abhijit