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 : 30-05-2017
ORA-29820

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

  • ora-26013 : List allocated may not be big enough
  • ora-30658 : attempt was made to create a temporary table with EXTERNAL organization
  • ora-33006 : (XSAGDNGL02) The relation workspace object is not related to itself.
  • ora-30129 : invalid function argument received
  • ora-30190 : reserved for future use
  • ora-31436 : duplicate change source string
  • ora-30440 : can't fast refresh;refresh complete or set event 30441 for partial refresh
  • ora-29841 : invalid option for ALTER INDEXTYPE
  • ora-40291 : model cost not available
  • ora-29275 : partial multibyte character
  • ora-12468 : max write level does not equal max read level
  • ora-16061 : Log file status has changed
  • ora-01943 : IDENTIFIED BY already specified
  • ora-36702 : (XSRELTBL05) The format of the HIERHEIGHT function is: HIERHEIGHT(relation [,] level) level >= 1.
  • ora-25231 : cannot dequeue because CONSUMER_NAME not specified
  • ora-13509 : error encountered during updates to a AWR table
  • ora-35578 : (SQLOUT11) SQL cursor 'number' cannot be used with CURRENT OF syntax
  • ora-13208 : internal error while evaluating [string] operator
  • ora-39091 : unable to determine logical standby and streams status
  • ora-14461 : cannot REUSE STORAGE on a temporary table TRUNCATE
  • ora-01622 : thread number must be specified - default not specific
  • ora-25203 : invalid value string, DELAY should be non-negative
  • ora-19553 : device name string is invalid
  • ora-09921 : Unable to get information label from connection
  • ora-00024 : logins from more than one process not allowed in single-process mode
  • ora-08342 : sropen: failed to open a redo server connection
  • ora-15202 : cannot create additional ASM internal change segment
  • ora-26098 : direct path context is not prepared
  • ora-26079 : file "string" is not part of table string.string
  • ora-01660 : tablespace 'string' is already permanent
  • 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.