Re: function based indexes

But why is that when i try to create a functional-index TRUNC([date-field]), i am not able to create as a schema owner?

i am, however, able to do so when i logged in as a SYSTEM owner.

please advise.

Originally posted by Emerald
> Do you have Enterprize edition of the database? Function based
> indexes can
> be created only in Enterprite edition.
> Kumar wrote in message
> news:bce41b15.0211141802.7872a762_at_posting.google.com"]news:bce4-
> 1b15.0211141802.7872a762_at_posting.google.com[/url]...
> > Hi
> > I am trying to create a function based index and getting
> > ORA-00439 : feature not enabled function based indexes.
> > I looked in v$option table and i find the parameter "function
> based
> > indexes" with value false.
> > Question: how do i make it true (to enable fn based index)
> > I tried like this:
> > " update v$option set value ='true' where parameter like
> > 'Function-based indexes'
> > I got an error saying can only select from fixed
> tables/views
> > Thanks for any responses
> kumar

--
Posted via http://dbforums.com