ORA-01986: OPTIMIZER_GOAL is obsolete

Cause : An obsloete paarmeter,O PTIMIZRE_GOAL,w as refreenced.

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Use th eOPTIMIEZR_MODEp arametre.

update : 24-09-2017
ORA-01986

ORA-01986 - OPTIMIZER_GOAL is obsolete
ORA-01986 - OPTIMIZER_GOAL is obsolete

  • ora-32509 : watchpoint was already deleted
  • ora-00093 : %s must be between string and string
  • ora-19908 : datafile string has invalid checkpoint
  • ora-36843 : (XSLMGEN13) Dimension string.string!string hierarchy string is missing a PHYSICALNAME property value
  • ora-28663 : Logging/Nologging attribute can not be specified in the statement ALTER TABLE ADD OVERFLOW
  • ora-28668 : cannot reference mapping table of an index-organized table
  • ora-02262 : ORA-string occurs while type-checking column default value expression
  • ora-25126 : Invalid name specified for BUFFER_POOL
  • ora-28583 : remote references are not permitted during agent callbacks
  • ora-03290 : Invalid truncate command - missing CLUSTER or TABLE keyword
  • ora-39147 : cannot migrate Data Pump queue table ownership to this instance
  • ora-06251 : NETNTT: cannot translate address file name
  • ora-00070 : command string is not valid
  • ora-02296 : cannot enable (string.string) - null values found
  • ora-39302 : schema clone operation failed
  • ora-13034 : Invalid data in the SDO_ORDINATE_ARRAY in SDO_GEOMETRY object
  • ora-25009 : Nested table clause allowed only for INSTEAD OF triggers
  • ora-25302 : Operation not possible for non-buffered queue string
  • ora-06556 : the pipe is empty, cannot fulfill the unpack_message request
  • ora-39209 : Parameter string requires privileges.
  • ora-02830 : Segment could not be split - no free segments available
  • ora-29926 : association already defined for the object
  • ora-30163 : The thread safety initialization failed
  • ora-01150 : cannot prevent writes - file string has online backup set
  • ora-32510 : cannot create watchpoint on unreadable memory
  • ora-10997 : another startup/shutdown operation of this instance inprogress
  • ora-31452 : invalid value string for parameter, expecting: Y or N
  • ora-32167 : No payload set on the Message
  • ora-22926 : specified trim length is greater than current LOB value's length
  • ora-24168 : rule string.string cannot have default evaluation context
  • Oracle Database Error Messages



    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.