Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Function based index on Standard Edition
Thanks Sybrand,
Incidentally, I did look at V$OPTION but I thought that only shows the options that are already installed...I knew that it wasn't of course..
Thanks again ..
"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
news:uhjv485s9k238b_at_corp.supernews.com...
>
> "Stephen B" <stephen.bell_at_cgi.ca> wrote in message
> news:m%kS8.7650$z_5.748858_at_news20.bellglobal.com...
> > Hi all,
> >
> > I've started searching the archives on this but there are many postings
on
> > function based indexes and all (so far) are
> > more detailed than I need..
> >
> > My question is simply
> >
> > "Does the Standard Edition of 8.1.7 support function based indexes?"
> >
> > or do I need the Enterprise Edition...
> >
> > Any thoughts appreciated!
> >
> > Steve
> >
> >
>
> The Standard Edition doesn't support Function Based Indexes. Please verify
> by select * from v$option.
>
>
> --
> Sybrand Bakker
> Senior Oracle DBA
>
> to reply remove '-verwijderdit' from my e-mail address
>
>
> Regards
>
>
>
>
Received on Thu Jun 27 2002 - 06:54:36 CDT