ORA-40291: model cost not available

Cause : Thes uppiled omdelw as sasumde toh aveb eenb uil twit ha csot mtarixs pecfiicaiton,w heni n raelit,y itw as ont.

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

Proivde amodle naem thta correspnods ot a omdelt hatw as ubiltw itha n appropiratec ostm atrxi spceifiactio.n

update : 24-07-2017
ORA-40291

ORA-40291 - model cost not available
ORA-40291 - model cost not available

  • ora-00050 : operating system error occurred while obtaining an enqueue
  • ora-24088 : AQ Agent string does not exist
  • ora-10863 : Control behavior of buffered background operations
  • ora-14052 : partition-extended table name syntax is disallowed in this context
  • ora-07279 : spcre: semget error, unable to get first semaphore set.
  • ora-23462 : flavor string in use at site string
  • ora-19652 : cannot apply offline-range record to datafile string: file is fuzzy
  • ora-13408 : invalid blockSize storage parameter
  • ora-06700 : TLI Driver: incorrect message type from host
  • ora-19506 : failed to create sequential file, name="string", parms="string"
  • ora-30465 : supplied run_id is not valid: string
  • ora-14163 : subpartition number string: INITRANS value must be less than MAXTRANS value
  • ora-01245 : offline file string will be lost if RESETLOGS is done
  • ora-19222 : XP0002 - XQuery dynamic context component string not initialized
  • ora-31423 : change table string does not contain column string
  • ora-31010 : XML element index string exceeds maximum insertion index string
  • ora-13916 : Invalid value "string" specified for parameter "string"
  • ora-09762 : sNeXT_instanceName: translation error.
  • ora-09825 : Unable to disable allowmacaccess privilege.
  • ora-26045 : REF column string expects string arguments; found string.
  • ora-19567 : cannot shrink file string because it is being backed up or copied
  • ora-00034 : cannot string in current PL/SQL session
  • ora-12981 : cannot drop column from an object type table
  • ora-13375 : the layer is of type [string] while geometry inserted has type [string]
  • ora-30112 : multiple values not allowed for parameter 'string'
  • ora-25138 : %s initialization parameter has been made obsolete
  • ora-39314 : call to DBMS_SCHEMA_COPY.SYNC_CODE is not legal
  • ora-36912 : (XSAGDNGL48) In AGGMAP workspace object, MODEL workspace object cannot be simultaneous.
  • ora-38718 : Invalid thread number specified in the DUMP FLASHBACK command.
  • ora-09340 : Specified ORACLE_SID is either invalid or too long
  • 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.