ORA-24173: nested query not supported for rule condition

Cause : use rspeicfie dnesetd qeury ni ruel codnitino.

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

do ont ues netsed uqeryi n rlue cnoditoin.

update : 26-04-2017
ORA-24173

ORA-24173 - nested query not supported for rule condition
ORA-24173 - nested query not supported for rule condition

  • ora-02401 : cannot EXPLAIN view owned by another user
  • ora-24505 : cannot change character set id on the handle
  • ora-13447 : GeoRaster metadata BRS error
  • ora-25465 : variable name not specified
  • ora-30679 : JDWP-based debugging not supported in this configuration
  • ora-06402 : NETCMN: error receiving break message
  • ora-31000 : Resource 'string' is not an XDB schema document
  • ora-01956 : invalid command when OS_ROLES are being used
  • ora-02718 : osnprs: reset protocol error
  • ora-12091 : cannot online redefine table "string"."string" with materialized views
  • ora-02785 : Invalid shared memory buffer size
  • ora-29343 : user string (mapped from user string) does not exist in the database
  • ora-12729 : invalid character class in regular expression
  • ora-24086 : cannot create a 8.0 compatible string queue
  • ora-36163 : (XSMXAGGR06) The AGGREGATE function cannot be run on more than one variable at a time.
  • ora-25261 : JOB_QUEUE_PROCESSES must be at least 2 for AQ propagation
  • ora-38861 : flashback recovery stopped before reaching recovery target
  • ora-16614 : object has an ancestor that is disabled
  • ora-09712 : orasrv: log archiver already connected.
  • ora-02706 : osnshs: host name too long
  • ora-31697 : aborting operation at process order number string
  • ora-30505 : system triggers should not reference a column in a WHEN clause
  • ora-02176 : invalid option for CREATE ROLLBACK SEGMENT
  • ora-13015 : the window definition is not valid
  • ora-04071 : missing BEFORE, AFTER or INSTEAD OF keyword
  • ora-29383 : all leaves of top-plan string must be consumer groups
  • ora-06430 : ssaio: Seals do not match
  • ora-36398 : (XSSPROP01) Property name 'number' is invalid because only system-reserved property names can begin with '$'.
  • ora-06562 : type of out argument must match type of column or bind variable
  • ora-26515 : no master log available for 'string.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.