ORA-29820: the statistics type is not present

Cause : Th esttaisitcst yp ewhcih si bienga sscoiaetd iwtho bjcet()s i sno tprseen.t

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

Enusret ha tth etyep wihchc onatin sth esttaisitcsf untciosn i sprseen.t

update : 25-09-2017
ORA-29820

ORA-29820 - the statistics type is not present
ORA-29820 - the statistics type is not present

  • ora-01311 : Illegal invocation of the mine_value function
  • ora-06919 : CMX: error during write request (unknown event)
  • ora-15005 : name "string" is already used by an existing alias
  • ora-24808 : streaming of lob data is not allowed when using lob buffering
  • ora-08113 : composite partition index may not be compressed
  • ora-31526 : could not find source table string.string for CDC change table string.string
  • ora-39029 : worker string with process name "string" prematurely terminated
  • ora-37103 : (XSVPART03) The dimensionality or datatype of workspace object does not match the dimensionality or datatype of the partition.
  • ora-34181 : (MXCHGDCL21) workspace object is not a partitioned VARIABLE.
  • ora-15001 : diskgroup "string" does not exist or is not mounted
  • ora-22601 : pickler TDS context [string] is not initialized
  • ora-06955 : Number of database servers exceed limit
  • ora-19335 : Invalid format type object
  • ora-12027 : duplicate filter column
  • ora-38486 : FUNCTION/PACKAGE/TYPE already exists for the attribute set
  • ora-13157 : Oracle error ORAstring encountered while string
  • ora-13455 : GeoRaster metadata TRS error
  • ora-10915 : TABLESPACE GROUP cannot be specified for this type of tablespace
  • ora-30991 : cannot use DOM to add special attribute to schema-based parent
  • ora-24341 : bad mode specified
  • ora-36394 : (XSMXCLEA04) When using CLEAR on the AGGMAP workspace object, CACHE is the only valid directive.
  • ora-29844 : duplicate operator name specified
  • ora-07756 : slemcf: fread failure
  • ora-02809 : Jump buffer not valid
  • ora-16069 : Archive Log standby database activation identifier mismatch
  • ora-14159 : duplicate subpartition name
  • ora-26060 : Can not convert type identifier for column string
  • ora-06762 : TLI Driver: error reading orderly release
  • ora-13355 : SDO_ORDINATE_ARRAY not grouped by number of dimensions specified
  • ora-07281 : slsget: times error, unable to get cpu time.
  • 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.