ORA-14008: missing THAN keyword

Cause : keywor dTHAN msising

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

supplym issingk eyword

update : 26-05-2017

ORA-14008 - missing THAN keyword
ORA-14008 - missing THAN keyword

  • ora-03278 : duplicate ALLOCATE EXTENT option specification
  • ora-33445 : (ESDREAD15) Discarding compiled code for workspace object because workspace object and workspace object, which were not partition-dependent when the code was compiled, are now partition-dependent.
  • ora-34489 : (MXMAINT06) You cannot maintain workspace object because it is a SURROGATE.
  • ora-02731 : osnrnf: malloc of buffer failed
  • ora-02171 : invalid value for MAXLOGHISTORY
  • ora-22894 : cannot add constraint on existing unscoped REF columns of non-empty tables
  • ora-12213 : TNS:incomplete PREFERRED_CMANAGERS binding in TNSNAV.ORA
  • ora-22859 : invalid modification of columns
  • ora-13602 : The specified parameter string is not valid for task or object string.
  • ora-22130 : buffer size [string] is less than the required size [string]
  • ora-19273 : XQ0053 - empty string in namespace declaration
  • ora-07231 : slemcc: invalid file handle, seals do not match.
  • ora-00268 : specified log file does not exist 'string'
  • ora-13919 : Cannot specify values for parameter "string" and for parameter "string"
  • ora-00076 : dump string not found
  • ora-31650 : timeout waiting for master process response
  • ora-01743 : only pure functions can be indexed
  • ora-09351 : Windows 32-bit Two-Task driver unable to allocate shared memory
  • ora-01195 : online backup of file string needs more recovery to be consistent
  • ora-30365 : left relation in the JOIN KEY clause cannot be same as right
  • ora-00286 : no members available, or no member contains valid data
  • ora-01479 : last character in the buffer is not Null
  • ora-39211 : unable to retrieve dumpfile information as specified
  • ora-37040 : (XSACQUIRE_DEP_LOCKED) Composite, concat, dimension map, or internal partition workspace object is locked by another user.
  • ora-13788 : invalid recommendation type
  • ora-01910 : TABLES keyword expected
  • ora-01083 : value of parameter "string" is inconsistent with that of other instances
  • ora-31480 : staging database and source database cannot be the same
  • ora-31099 : XDB Security Internal Error
  • ora-10644 : SYSTEM tablespace cannot be default temporary tablespace
  • 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.