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 : 17-08-2017
ORA-22818

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

  • ora-29391 : %s and string must be mandatory to create a mandatory plan directive
  • ora-40302 : invalid classname string in cost matrix specification
  • ora-39130 : Object type string not imported. Base object name conflicts with the master table
  • ora-23538 : cannot explicitly refresh a NEVER REFRESH materialized view ("string")
  • ora-02793 : Close of asynchronous I/O failed.
  • ora-07622 : smscre: $CREATE failure
  • ora-22625 : OCIAnyData is not well-formed
  • ora-37121 : AW Spreadsheet invalidated
  • ora-01045 : user string lacks CREATE SESSION privilege; logon denied
  • ora-25217 : enqueue failed, visibility must be IMMEDIATE for queue string.string
  • ora-19754 : error reading from change tracking file
  • ora-19718 : length for command id longer than string
  • ora-31623 : a job is not attached to this session via the specified handle
  • ora-02756 : osnfsmnam: name translation failure
  • ora-16589 : Data Guard Connection process detected a network transfer error
  • ora-36636 : (XSDUNION04) The unique concat dimension workspace object cannot be changed to NOT UNIQUE, because it is a base of at least one other unique concat dimension.
  • ora-14287 : cannot REBUILD a partition of a Composite Range partitioned index
  • ora-16716 : clearing parameter LOG_ARCHIVE_DEST failed
  • ora-27013 : skgfqdel: cannot delete an open file
  • ora-02763 : Unable to cancel at least one request
  • ora-06539 : target of OPEN must be a query
  • ora-02398 : exceeded procedure space usage
  • ora-31101 : Token "string" not given while locking resource "string"
  • ora-12925 : tablespace string is not in force logging mode
  • ora-19322 : An error occurred while reading from host (string): port (string)
  • ora-26709 : Streams RFS restart
  • ora-01189 : file is from a different RESETLOGS than previous files
  • ora-01877 : string is too long for internal buffer
  • ora-01624 : log string needed for crash recovery of instance string (thread string)
  • ora-07848 : sllfrb: $GET failure
  • 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.