ORA-01031 with Create Index for a Function Based Index

Hello all,
  I'm getting ORA-01031: insufficient privileges while trying to create a function index.

• Statements -- create table date_ind_test ( id number not null, creation_date date );

  create index date_ind on date_ind_test (to_char(creation_date,'DHH24'));

• Error returned -- create index date_ind on date_ind_test (to_char(creation_date,'DHH24')) * ERROR at line 1: ORA-01031: insufficient privileges
• End Error

  Any ideas on privileges to be set up to use function indexes?

  Thanks
  Rishi

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Feb 18 2000 - 22:08:46 CST