Re: function based indexes

cheechong wrote:

> i was using Oracle 9i version 9.2.
>
> i used to be able to create such a functional index in Oracle 8.1.7.
>
> any idea? thanks.
>
> Originally posted by Da Morgan
> > 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"]n-
> > ews:bce41b15.0211141802.7872a762_at_posting.google.com[/url]"]-
> > news:bce4-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/http://dbforums.com
> >
> > In what version and edition of Oracle?
> >
> Daniel Morgan
>
> --
> Posted via http://dbforums.com

Did you check to see if the following are set in the initSID.ora / spfile?

query_rewrite_enabled=TRUE
query_rewrite_integrity=TRUSTED

Daniel Morgan Received on Sat Mar 01 2003 - 00:53:49 CST