ORA-16953: Type of SQL statement not supported.

Cause : Thist ype fo SQLs tateemnt cuold nto be rpocesesd.

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


update : 28-04-2017

ORA-16953 - Type of SQL statement not supported.
ORA-16953 - Type of SQL statement not supported.

  • ora-33918 : (MAKEDCL33) You cannot define a surrogate of dimension workspace object because it is a string.
  • ora-02379 : profile string already exists
  • ora-30960 : The entity is neither an XPATH nor a NAMESPACE.
  • ora-32579 : password for SYSTEM already specified
  • ora-12681 : Login failed: the SecurID card does not have a pincode yet
  • ora-29807 : specified operator does not exist
  • ora-01772 : Must specify a value for LEVEL
  • ora-19601 : output file is string string (string)
  • ora-22307 : operation must be on a user-defined type
  • ora-09870 : spini: failure initializing maximum number of open files.
  • ora-06575 : Package or function string is in an invalid state
  • ora-06133 : NETTCP: file not found
  • ora-24025 : invalid value string, QUEUE_PAYLOAD_TYPE should be RAW or an object type
  • ora-09364 : Windows 3.1 Two-Task driver unable to create hidden window
  • ora-12591 : TNS:event signal failure
  • ora-32118 : Cannot perform operation on a null FILE
  • ora-32775 : cannot change size attributes of read only tablespace string
  • ora-28364 : invalid wallet operation
  • ora-19575 : expected string blocks in file string, found string
  • ora-12437 : invalid policy option: string
  • ora-27373 : unknown or illegal event source queue
  • ora-09872 : TASDEF_CREATE: create failure in creating ?/dbs/tasdef@.dbf.
  • ora-24281 : invalid access past the maximum size of LOB parameter string
  • ora-27046 : file size is not a multiple of logical block size
  • ora-13050 : unable to construct spatial object
  • ora-36914 : (XSAGDNGL50) In AGGMAP workspace object, LOAD_STATUS valueset workspace object contains both a child and it's ancestor.
  • ora-13636 : The specified value provided for parameter string is not valid for this advisor.
  • ora-32035 : unreferenced query name defined in WITH clause
  • ora-31417 : column list contains control column string
  • ora-06754 : TLI Driver: unable to get local host address
  • 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.