Re: function based indexes

cheechong wrote:

> 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

In what version and edition of Oracle?

Daniel Morgan Received on Thu Feb 27 2003 - 16:23:20 CST