ORA-24152: cannot drop evaluation context string.string with dependents

Cause : hT evelaauitnoc noettxs itllb lenosgt oosemr luseo rurels te,sc naon tebd orppde

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

odn tod or pnae avultaoi noctnxe tiwhtd peneedtn siwhtuo tofcr epoitno

update : 23-09-2017
ORA-24152

ORA-24152 - cannot drop evaluation context string.string with dependents
ORA-24152 - cannot drop evaluation context string.string with dependents

  • ora-37041 : (XSACQUIRE_DEP_TIMEOUT) Composite, concat, dimension map, or internal partition workspace object is locked by another user and the WAIT timed out.
  • ora-16586 : could not edit database property through instance
  • ora-02755 : osnfsmcre: cannot create chared memory file ?/dbs/ftt_.dbf
  • ora-39705 : component 'string' not found in registry
  • ora-32147 : Environment not specified
  • ora-31454 : invalid value string for operation parameter, expecting: ADD or DROP
  • ora-12926 : FORCE LOGGING option already specified
  • ora-02403 : plan table does not have correct format
  • ora-26036 : subpartition load specified but table string is not subpartitioned
  • ora-40215 : model string is incompatible with current operation
  • ora-13829 : SQL profile named string already exists
  • ora-06434 : ssaio: read error, unable to read requested block from database file.
  • ora-23374 : object group "string"."string" already exists
  • ora-12549 : TNS:operating system resource quota exceeded
  • ora-00050 : operating system error occurred while obtaining an enqueue
  • ora-29399 : user string does not have privilege to switch to consumer group string
  • ora-12480 : specified clearance labels not within the effective clearance
  • ora-08178 : illegal SERIALIZABLE clause specified for user INTERNAL
  • ora-24410 : scrollable cursor max size exceeded
  • ora-24338 : statement handle not executed
  • ora-30649 : missing DIRECTORY keyword
  • ora-24804 : Lob read/write functions called while another OCI LOB read/write streaming is in progress
  • ora-22928 : invalid privilege on directories
  • ora-30727 : duplicate referential constraint for a REF column
  • ora-31658 : specifying a schema name requires a table name
  • ora-13295 : geometry objects are in different coordinate systems
  • ora-02054 : transaction string in-doubt
  • ora-13757 : "SQL Tuning Set" "string" owned by user "string" is active.
  • ora-08106 : cannot create journal table string.string
  • ora-14137 : Table in partially dropped state, submit DROP TABLE PURGE
  • 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.