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

From: Heggelund <d92hegge_at_ix_prod.hfk.mil.no>
Date: 1997/03/13
Message-ID: <1997Mar13.122312.18992@ix_prod.hfk.mil.no>#1/1

Hi,
'cost' is no longer a valid value for optimizer_mode. You should use choose, all_rows or first_rows. If you are not sure which value to use or if you are running 7.0 / 7.1 then you should use the value 'choose'.

Rgds
Steinar

Jens Wartenberg (wartenberg_id_at_ibm.net) wrote:
: 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
: -------------------------------------------------------------
Received on Thu Mar 13 1997 - 00:00:00 CST