ORA-22818: subquery expressions not allowed here

Cause : An attempt was made to use a subquery expression where these are not supported.

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

Rewrite the statement without the subquery expression.

update : 27-04-2017

ORA-22818 - subquery expressions not allowed here
ORA-22818 - subquery expressions not allowed here

  • ora-08431 : raw data missing zero as defined in picture
  • ora-13785 : missing target object for tuning task "string"
  • ora-25272 : Signature does not exist for the given reciever and message id.
  • ora-26002 : Table string has index defined upon it.
  • ora-09930 : LUB of two labels is invalid
  • ora-19999 : skip_row procedure was called
  • ora-26740 : cannot downgrade because there are file groups
  • ora-19903 : test recovery not allowed when recovering to new incarnation
  • ora-01734 : illegal parameters - EXTENT MIN higher than EXTENT MAX
  • ora-15122 : ASM file name 'string' contains an invalid file number
  • ora-07825 : sspsck: $QIO failure at AST level
  • ora-13113 : invalid tg_layer_id in sdo_topo_geometry constructor
  • ora-04930 : open sequence number failed or initial state is valid
  • ora-29800 : invalid name for operator
  • ora-01417 : a table may be outer joined to at most one other table
  • ora-35078 : (QFHEAD05) An EIF extension file header for string is not in the correct format.
  • ora-12822 : duplicate option in PARALLEL clause
  • ora-01781 : UNRECOVERABLE cannot be specified without AS SELECT
  • ora-25107 : duplicate TABLESPACE option specification
  • ora-29539 : Java system classes already installed
  • ora-01720 : grant option does not exist for 'string.string'
  • ora-27049 : unable to seek to and read the last block
  • ora-23351 : parameter datatype string for procedure string not supported
  • ora-22996 : NEXT extent size is smaller than LOB chunksize
  • ora-07607 : szaud: $SNDOPR failure
  • ora-18000 : invalid outline name
  • ora-31639 : unexpected data found
  • ora-19610 : directory block string is corrupt
  • ora-10701 : Dump direct loader index keys
  • ora-19334 : Invalid column specification for CREATE_DBURI operator
  • 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.