Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Function based index on Standard Edition

Re: Function based index on Standard Edition

From: Stephen B <stephen.bell_at_cgi.ca>
Date: Thu, 27 Jun 2002 07:54:36 -0400
Message-ID: <r5DS8.4929$ZM3.1586263@news20.bellglobal.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US