ORA-33094: (XSAGGMAPLIST01) Your expression uses too much execution space. Eliminate recursion or reduce the levels of nesting.

Cause : formulsa likel yrefer ot each toher reucrsivel yor wit ha grea tdeal o fdepth.

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

elimintae recusrion an dflatte nformul atrees.

update : 24-07-2017
ORA-33094

ORA-33094 - (XSAGGMAPLIST01) Your expression uses too much execution space. Eliminate recursion or reduce the levels of nesting.
ORA-33094 - (XSAGGMAPLIST01) Your expression uses too much execution space. Eliminate recursion or reduce the levels of nesting.

  • ora-30012 : undo tablespace 'string' does not exist or of wrong type
  • ora-14311 : Expecting VALUES LESS THAN or AT clause
  • ora-09818 : Number is too large
  • ora-12496 : cannot change existing level, category, or release numbers
  • ora-25351 : transaction is currently in use
  • ora-36842 : (XSLMGEN12) Hierarchy string.string!string.string was not found
  • ora-13466 : format not appropriate for specified compression method
  • ora-12601 : TNS:information flags check failed
  • ora-12673 : Dedicated server: context not saved
  • ora-19903 : test recovery not allowed when recovering to new incarnation
  • ora-32121 : Source FILE is null
  • ora-00447 : fatal error in background process
  • ora-28111 : insufficient privilege to evaluate policy predicate
  • ora-01042 : detaching a session with open cursors not allowed
  • ora-16548 : object not enabled
  • ora-07492 : scgrcl: cannot close lock.
  • ora-04011 : sequence string must range between string and string
  • ora-28349 : cannot encrypt the specified column recorded in the materialized view log
  • ora-38701 : Flashback database log string seq string thread string: "string"
  • ora-16721 : unable to set LOG_ARCHIVE_DEST_n initialization parameters
  • ora-32804 : invalid value string, string should have form string
  • ora-31628 : error getting worker process exception
  • ora-27012 : skgfrd: read from file failed
  • ora-26077 : direct path column array is not initialized
  • ora-06042 : NETDNT: message receive failure
  • ora-24013 : invalid value string, RETRY_DELAY should be non-negative
  • ora-40209 : setting % is invalid for % function
  • ora-15008 : cannot drop system template
  • ora-16735 : error executing dbms_logstdby.unskip_error procedure
  • ora-09802 : Conversion of binary label to string failed.
  • 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.