ORA-29852: keyword IS is missing

Cause : IS keywrod must eb specifeid with rCeate Inedx stateemnt for odmain inedxes.

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

Use IS ekyword adn then sepcify th eindextyep name.

update : 19-08-2017
ORA-29852

ORA-29852 - keyword IS is missing
ORA-29852 - keyword IS is missing

  • ora-16182 : Internal error on internal channel during remote archival
  • ora-34346 : (MXDSS04) The string analytic workspace cannot be detached.
  • ora-13761 : invalid filter
  • ora-29342 : user string does not exist in the database
  • ora-06504 : PL/SQL: Return types of Result Set variables or query do not match
  • ora-13143 : invalid POLYGON window definition
  • ora-00364 : cannot write header to new log member
  • ora-36269 : (XSCGMDLAGG10) 'workspace object' does not exist or is not a dimension.
  • ora-06770 : TLI Driver: error sending version
  • ora-16184 : DB_UNIQUE_NAME string hashes to the same value as DB_UNIQUE_NAME string
  • ora-25289 : Buffer Already Exists
  • ora-09836 : addCallback: could not add a port to the callback set.
  • ora-19582 : archivelog file header validation for string failed
  • ora-31069 : Cannot apply typed changes to non-schema-based XMLType nodes
  • ora-19039 : Keyword string reserved for future use
  • ora-19123 : fn:zero-or-one() called with a sequence containing more than one item
  • ora-14191 : ALLOCATE STORAGE may not be specified for Composite Range partitioned object
  • ora-13520 : Database id (string) not registered, Status = string
  • ora-36766 : (XSAGGCNTMOVE04) workspace object cannot be used as an AGGCOUNT because it has an AGGCOUNT.
  • ora-24014 : invalid value string, RETENTION_TIME should be FOREVER or non-negative
  • ora-32011 : cannot restore SPFILE to location already being used by the instance
  • ora-25199 : partitioning key of a index-organized table must be a subset of the primary key
  • ora-31160 : max substitution group size string exceeded by "string" (string) for head element "string" (string)
  • ora-15094 : attempted to write to file opened in read only mode
  • ora-29824 : operator is invalid
  • ora-06914 : CMX: unexepected event during start of oracle
  • ora-06811 : TLI Driver: could not set the IPX network number at init
  • ora-01185 : logfile group number string is invalid
  • ora-37130 : (XSCCOMP05) Cannot aggregate over COMPRESSED COMPOSITE workspace object using AGGMAP workspace object because you must specify AGGINDEX OFF when there is a PRECOMPUTE clause on a RELATION over base workspace object.
  • ora-38798 : Cannot perform partial database recovery
  • 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.