ORA-29929: missing SCAN Keyword

Cause : Th escna cnotetx i sno tspceifeid.

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

Supplyt heS CA Nkewyor.d

update : 25-05-2017
ORA-29929

ORA-29929 - missing SCAN Keyword
ORA-29929 - missing SCAN Keyword

  • ora-10936 : trace name context forever
  • ora-26718 : transaction limit reached
  • ora-26103 : V6 or V7 data file used to create control file
  • ora-14029 : GLOBAL partitioned index must be prefixed
  • ora-00085 : current call does not exist
  • ora-30387 : invalid rewrite mode for REWRITE_EQUIVALENCE API
  • ora-13916 : Invalid value "string" specified for parameter "string"
  • ora-15115 : missing or invalid ASM disk size specifier
  • ora-12679 : Native services disabled by other process but required
  • ora-13419 : cannot perform mosaick operation on the specified table column
  • ora-16517 : the object handle is invalid
  • ora-32015 : unable to restore SPFILE
  • ora-01123 : cannot start online backup; media recovery not enabled
  • ora-12063 : unable to apply transaction from site string
  • ora-23446 : duplicate template site
  • ora-37020 : (XSMULTI01) Analytic workspace string is not in MULTI mode.
  • ora-22866 : default character set is of varying width
  • ora-22809 : nonexistent attribute
  • ora-16168 : LGWR network server could not switch to blocking mode
  • ora-14275 : cannot reuse lower-bound partition as resulting partition
  • ora-32021 : parameter value longer than string characters
  • ora-31155 : attribute string not in XDB namespace
  • ora-04069 : cannot drop or replace a library with table dependents
  • ora-36380 : (AGGRECURSE) AGGREGATE was called recursively, which is not allowed.
  • ora-01312 : Specified table/column does not exist
  • ora-09872 : TASDEF_CREATE: create failure in creating ?/dbs/tasdef@.dbf.
  • ora-34897 : (PPMONTHS01) Blank lines are not allowed in the MONTHNAMES option.
  • ora-30155 : An I/O Error occured during an OCIFile function call
  • ora-37018 : (XSACQUIRE03) Multiwriter operations are not supported for object workspace object.
  • ora-37084 : Output valueset string must match string's dimensionality
  • 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.