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 : 23-04-2017
ORA-29820

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

  • ora-36800 : (XSTBLFUNC00) The OLAP_TABLE function can only have a single LOOP statement within the LIMITMAP
  • ora-00024 : logins from more than one process not allowed in single-process mode
  • ora-13905 : Critical or warning threshold have incorrect values
  • ora-31453 : invalid value string for parameter, expecting: Y, N, or NULL
  • ora-09758 : osnipn: could not check port in name server.
  • ora-13616 : The current user string has not been granted the ADVISOR privilege.
  • ora-12915 : Cannot alter dictionary managed tablespace to read write
  • ora-12856 : cannot run parallel query on a loopback connection
  • ora-04014 : descending sequences that CYCLE must specify MINVALUE
  • ora-31623 : a job is not attached to this session via the specified handle
  • ora-24770 : cannot forget a prepared transaction
  • ora-07213 : slgcs: times error, unable to get wall clock.
  • ora-00486 : ASMB process terminated with error
  • ora-16159 : Cannot change protected standby destination attributes
  • ora-01606 : gc_files_to_locks not identical to that of another mounted instance
  • ora-10388 : parallel query server interrupt (failure)
  • ora-37135 : (XSCCOMP10) Cannot aggregate over COMPRESSED COMPOSITE workspace object using AGGMAP workspace object. The RELATION statement for dense dimension workspace object must precede RELATION statements over the bases of the COMPRESSED COMPOSITE.
  • ora-02297 : cannot disable constraint (string.string) - dependencies exist
  • ora-30074 : GLOBAL partitioned index on TIME/TIMESTAMP WITH TIME ZONE not allowed
  • ora-25148 : ONLINE option not permitted
  • ora-39711 : critical patch number less than last installed CPU number
  • ora-31025 : Invalid document element
  • ora-39156 : error parsing dump file name "string"
  • ora-29957 : cannot create a function-based domain index on a string table
  • ora-02763 : Unable to cancel at least one request
  • ora-30156 : Out of disk space
  • ora-16746 : resource guard encountered errors during database mount
  • ora-28120 : driving context already exists
  • ora-32736 : Hang analysis aborted due to wrong message type
  • ora-15113 : alias name 'string' refers to a directory
  • 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.