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 : 27-06-2017
ORA-29964

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

  • ora-39024 : wrong schema specified for job
  • ora-07491 : scgrcl: cannot cancel lock request.
  • ora-16618 : response document of size "string" bytes is too large
  • ora-24771 : cannot detach, prepare or forget a local transaction
  • ora-00381 : cannot use both new and old parameters for buffer cache size specification
  • ora-30398 : illegal JOIN KEY clause
  • ora-01679 : database must be mounted EXCLUSIVE and not open to activate
  • ora-24304 : datatype not allowed for this call
  • ora-19711 : cannot use reNormalizeAllFileNames while database is open
  • ora-01275 : Operation string is not allowed if standby file management is automatic.
  • ora-04087 : cannot change the value of ROWID reference variable
  • ora-13066 : wrong feature geometry or element type
  • ora-00040 : active time limit exceeded - call aborted
  • ora-23600 : cannot create PROPAGATION, string already exists
  • ora-14318 : DEFAULT partition must be last partition specified
  • ora-27039 : create file failed, file size limit reached
  • ora-12684 : encryption/crypto-checksumming: Diffie-Hellman seed too small
  • ora-29951 : warning in the execution of ODCIINDEXSPLITPARTITION routine
  • ora-39130 : Object type string not imported. Base object name conflicts with the master table
  • ora-23533 : object "string"."string" can not be cached
  • ora-06704 : TLI Driver: receive break message failed
  • ora-06953 : Not enough virtual memory
  • ora-02481 : Too many processes specified for events (max string)
  • ora-07570 : szrfc: $IDTOASC failure
  • ora-37116 : OLAP API table function error: (string)
  • ora-06702 : TLI Driver: cannot allocate context area
  • ora-12556 : TNS:no caller
  • ora-00203 : using the wrong control files
  • ora-01907 : TABLESPACE keyword expected
  • ora-12840 : cannot access a remote table after parallel/insert direct load txn
  • 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.