ORA-16955: Unknown error during SQL analyze.

Cause : The specified SQL statement failed to be analyzed.

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

This is an internal error, please contact Oracle support.

update : 24-06-2017

ORA-16955 - Unknown error during SQL analyze.
ORA-16955 - Unknown error during SQL analyze.

  • ora-01099 : cannot mount database in SHARED mode if started in single process mode
  • ora-04061 : existing state of string has been invalidated
  • ora-16233 : The table string.string is unsupported now
  • ora-23290 : This operation may not be combined with any other operation
  • ora-31509 : publication does not exist
  • ora-12609 : TNS: Receive timeout occurred
  • ora-01661 : tablespace 'string' is already temporary
  • ora-27076 : unable to set limit for open files
  • ora-12079 : materialized view options require COMPATIBLE parameter to be string or greater
  • ora-04078 : OLD and NEW values cannot be identical
  • ora-19105 : invalid XQueryX: expected text node - got string
  • ora-02714 : osnpwr: message send failure
  • ora-25449 : invalid variable name: string
  • ora-28237 : seed length too short
  • ora-31028 : Resource metadata length string exceeded maximum length string
  • ora-36666 : (XSDPART04) workspace object is not a concat dimension.
  • ora-39148 : unable to import data into pre-existing queue table string. Table_exists_action of string being ignored for this table
  • ora-30570 : SEGMENT SPACE MANAGEMENT option already specified
  • ora-39028 : cannot restart job from string state
  • ora-14097 : column type or size mismatch in ALTER TABLE EXCHANGE PARTITION
  • ora-29896 : Length of PARAMETER string longer than string characters
  • ora-01118 : cannot add any more database files: limit of string exceeded
  • ora-32123 : Attribute number is out of range
  • ora-26045 : REF column string expects string arguments; found string.
  • ora-01176 : data dictionary has more than the string files allowed by the controlfie
  • ora-13261 : geometry table string does not exist
  • ora-32025 : %s.string is not a table or view object.
  • ora-12152 : TNS:unable to send break message
  • ora-01593 : rollback segment optimal size (string blks) is smaller than the computed initial size (string blks)
  • ora-07477 : scgcmn: lock manager not initialized.
  • 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.