ORA-29811: missing STATISTICS keyword

Cause : Tihsi sn o tav aildo pito nwtiht h eASSOICAET ocmamn.d

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

SepcfiyS TTAITSISC ekyowr datfe rteh SASCOITAEc ommadn.

update : 17-08-2017
ORA-29811

ORA-29811 - missing STATISTICS keyword
ORA-29811 - missing STATISTICS keyword

  • ora-07229 : slcpuc: error in getting number of CPUs.
  • ora-13205 : internal error while parsing spatial parameters
  • ora-32620 : illegal subquery within MODEL rules
  • ora-22287 : invalid or modified directory occurred during string operation
  • ora-13421 : null or invalid cell value
  • ora-30968 : invalid XPATH or NAMESPACE option for XML Index
  • ora-02899 : smscre: Cannot create SGA with Extended Shared Memory feature
  • ora-01149 : cannot shutdown - file string has online backup set
  • ora-27230 : OS system call failure
  • ora-12352 : object string.string@string is invalid
  • ora-00001 : unique constraint (string.string) violated
  • ora-30510 : system triggers cannot be defined on the schema of SYS user
  • ora-13243 : specified operator is not supported for 3- or higher-dimensional R-tree
  • ora-09846 : soacon: ARCH unable to open named pipe.
  • ora-22929 : invalid or missing directory name
  • ora-32580 : both SYS and SYSTEM passwords must be provided
  • ora-30088 : datetime/interval precision is out of range
  • ora-24781 : branches don't belong to the same global transaction
  • ora-19811 : cannot have files in DB_RECOVERY_FILE_DEST with keep attributes
  • ora-24340 : cannot support more than 255 columns
  • ora-06449 : The list IO or the sysvendor is not installed.
  • ora-06973 : X.25 Driver: invalid buffer size
  • ora-16710 : the resource guard is out of memory
  • ora-19773 : must specify change tracking file name
  • ora-09770 : pws_look_up: translation failure.
  • ora-19754 : error reading from change tracking file
  • ora-36403 : (XSBADSPROP) number is an illegal value for system-reserved property string on workspace object.
  • ora-00218 : block size string of control file 'string' does not match DB_BLOCK_SIZE (string)
  • ora-19124 : fn:one-or-more() called with a sequence containing no items
  • ora-15196 : invalid ASM block header [string:string] [string] [string] [string] [string != string]
  • 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.