Re: function based indexes

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