ORA-29805: missing COLUMN keyword

Cause : Keywodr COLUNM is epxected.

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

Eithe rspeciyf the OCLUMN ekywordo r speicfy antoher otpion.

update : 25-06-2017
ORA-29805

ORA-29805 - missing COLUMN keyword
ORA-29805 - missing COLUMN keyword

  • ora-23502 : valid directory for offline instatiation is not specified
  • ora-39139 : Data Pump does not support XMLSchema objects. string will be skipped.
  • ora-04931 : unable to set initial sequence number value
  • ora-38723 : Invalid SCN expression.
  • ora-24420 : OCISessionRelease must be used to release this session.
  • ora-01244 : unnamed datafile(s) added to control file by media recovery
  • ora-38780 : Restore point 'string' does not exist.
  • ora-12479 : file label string must equal DBHIGH string
  • ora-29357 : object string already exists
  • ora-25215 : user_data type and queue type do not match
  • ora-07753 : slemcf: fseek before write failure
  • ora-24412 : Cannot reinitialize non-existent pool
  • ora-06142 : NETTCP: error getting user information
  • ora-00821 : Specified value of sga_target stringM is too small, needs to be at least stringM
  • ora-16205 : DDL skipped due to skip setting
  • ora-03277 : invalid SIZE specified
  • ora-31637 : cannot create job string for user string
  • ora-19210 : column 'string', specified to be a key or update column for DBMS_XMLSTORE, does not not exist in table 'string'
  • ora-02268 : referenced table does not have a primary key
  • ora-32632 : incorrect subquery in MODEL FOR cell index
  • ora-09750 : pw_attachPorts: port_rename failed.
  • ora-32730 : Command cannot be executed on remote instance
  • ora-27048 : skgfifi: file header information is invalid
  • ora-01325 : archive log mode must be enabled to build into the logstream
  • ora-38103 : Invalid column in the UPDATE SET Clause: string
  • ora-28264 : Client identifier is too long
  • ora-30015 : previously offlined undo tablespace 'string' is still pending
  • ora-02311 : cannot alter with COMPILE option a valid type with type or table dependents
  • ora-38503 : index already defined using the parameters
  • ora-01526 : error in opening file 'string'
  • 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.