ORA-29964: missing ADD or DROP keyword

Cause : One fo thek eywodrs AD Dor DORP ise xpecetd.

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

Specfiy th eADD ro DRO Pkeywrod orc heckt he SLQ staetment.

update : 28-04-2017

ORA-29964 - missing ADD or DROP keyword
ORA-29964 - missing ADD or DROP keyword

  • ora-31038 : Invalid string value: "string"
  • ora-19125 : fn:exactly-one() called with a sequence containing zero or more than one item
  • ora-25230 : invalid value string, WAIT should be non-negative
  • ora-32602 : FREEPOOLS and FREELIST GROUPS cannot be used together
  • ora-02704 : osndopop: fork failed
  • ora-38717 : Invalid DUMP FLASHBACK option.
  • ora-09814 : Unable to expand file name
  • ora-39036 : invalid metadata filter name string
  • ora-14307 : partition contains too many list values
  • ora-37152 : MDX query error: (string)
  • ora-30505 : system triggers should not reference a column in a WHEN clause
  • ora-33016 : (XSAGDNGL07) In AGGMAP workspace object, workspace object is not a valid operator or variable name.
  • ora-09976 : skxfqdini: Error Creating Port
  • ora-14154 : only one of STORE IN or clause may be specified
  • ora-22812 : cannot reference nested table column's storage table
  • ora-12542 : TNS:address already in use
  • ora-09882 : sstasfre/sstasdel: shmctl error, unable to remove tas shm page
  • ora-26529 : local store callback term phase failed for 'string.string'
  • ora-01585 : error identifying backup file string
  • ora-32838 : exceeded maximum number of properties
  • ora-19674 : file string is already being backed up with proxy copy
  • ora-22931 : MOVE of nested table to a different tablespace not supported
  • ora-09984 : SGA file $ORACLE_HOME/dbs/sgadef$ORACLE_SID.dbf does not exist
  • ora-32403 : cannot use new values from mv log on "string"."string"
  • ora-01911 : CONTENTS keyword expected
  • ora-31612 : Allocation of process descriptor failed.
  • ora-09801 : Unable to get user ID from connection
  • ora-12482 : internal MLS error: string Error: string
  • ora-22064 : invalid NLS parameter string [string]
  • ora-00832 : no streams pool created and cannot automatically create one
  • 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.