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 : 24-05-2017
ORA-29852

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

  • ora-03231 : the INITIAL extent may not be deallocated
  • ora-06761 : TLI Driver: error sending orderly release
  • ora-07339 : spcre: maximum number of semaphore sets exceeded.
  • ora-19280 : XQuery dynamic type mismatch: expected atomic value - got node
  • ora-27421 : usage of string not supported in a calendar definition
  • ora-14254 : cannot specify ALLOCATE STORAGE for a (Composite) Range or List partitioned table
  • ora-23602 : Invalid streams process type string
  • ora-02178 : correct syntax is: SET TRANSACTION READ { ONLY | WRITE }
  • ora-01167 : two files are the same file/group number or the same file
  • ora-28669 : bitmap index can not be created on an IOT with no mapping table
  • ora-14315 : cannot merge a partition with itself
  • ora-28178 : password not provided by proxy
  • ora-26708 : remote DDL not supported by STREAMS : dblink string
  • ora-28040 : No matching authentication protocol
  • ora-06607 : LU6.2 Driver: Reset occurred in send state
  • ora-24420 : OCISessionRelease must be used to release this session.
  • ora-06301 : IPA: Cannot allocate driver context
  • ora-19731 : cannot apply change to unverified plugged-in datafile string
  • ora-13344 : an arcpolygon geometry has fewer than five coordinates
  • ora-04034 : unable to shrink pool to specified size
  • ora-30360 : REF not supported with query rewrite
  • ora-32015 : unable to restore SPFILE
  • ora-15193 : Internal ASM tracing event number 15193
  • ora-14635 : only one resulting subpartition can be specified for MERGE SUBPARTITIONS
  • ora-27435 : chain job terminated abnormally
  • ora-01541 : system tablespace cannot be brought offline; shut down if necessary
  • ora-29935 : missing FROM keyword
  • ora-30973 : invalid Path Table option for XML Index
  • ora-27011 : skgfrd: cannot read from file opened for write
  • ora-06127 : NETTCP: unable to change username
  • 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.