Re: LCC-00111 Error. Will not use COST as optimizer ??

Thanks.
It works with RULE, CHOOSE and ALL_ROWS. So far so good.
Why wont it work with COST??

Kennedy, Kevin P wrote:
>
> Try CHOOSE instead of COST
>
> >----------
> >From: Jens Wartenberg[SMTP:wartenberg_id_at_IBM.NET]
> >Sent: Wednesday, March 12, 1997 3:20 PM
> >To: Multiple recipients of list ORACLE-L
> >Subject: LCC-00111 Error. Will not use COST as optimizer ??
> >
> >Hi,
> >When I try to startup the database with optimizer_mode in initxxx.ora
> >changed from RULE to COST , I get the following error
> >(translated from Danish):
> >LCC-00111 value is not within valid range (optimizer_mode).
> >Why do I get this error?
> >Any ideas/knowledge welcome.
> >
> >Regards
> >Jens Wartenberg email: wartenberg_id_at_ibm.net
> >-------------------------------------------------------------
> >WARTENBERG | People
> >Industri Data - Denmark | that make a difference
> >- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
> >IBM RS/6000 - IBM AIX - Oracle | For industrial needs
> >-------------------------------------------------------------
> >
> >------------And now a message from today's ORACLE-L sponsor---------------
> > To subscribe, unsubscribe or change subscription options
> > to ORACLE-L, send a message to LISTSERV_at_dbinfo.com.
> > ORACLE-L is a service of Kapur Business Systems, Inc.
> >--------------------------------------------------------------------------
> >
Received on Thu Mar 13 1997 - 00:00:00 CST