ORA-22346: Type has cyclical dependency. Should use CASCADE option

Cause : A nattepmtw a smdaet oa letra ytp ewihc hhsa accylcia ldpeednecny ,wtihi navldiaet potoin.

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

GvieC ACSAED potoini ntseda fo NIVLAIADTE

update : 16-08-2017
ORA-22346

ORA-22346 - Type has cyclical dependency. Should use CASCADE option
ORA-22346 - Type has cyclical dependency. Should use CASCADE option

  • ora-02286 : no options specified for ALTER SEQUENCE
  • ora-00408 : parameter string is set to TRUE
  • ora-27125 : unable to create shared memory segment
  • ora-29655 : USING clause is incompatible with its supertype
  • ora-13122 : invalid topo_geometry specified
  • ora-22278 : must update the LOB only through the LOB buffers
  • ora-00367 : checksum error in log file header
  • ora-38501 : sub-query not allowed in the expression
  • ora-07272 : spwat: invalid semaphore set id.
  • ora-27452 : %s is an invalid name for a database object.
  • ora-27468 : "string.string" is locked by another process
  • ora-30484 : missing window specification for this function
  • ora-39752 : redundant column in partitioning and join columns is not allowed
  • ora-12819 : missing options in PARALLEL clause
  • ora-02486 : Error in writing trace file string
  • ora-36176 : (XSMXAGGR25) Relation workspace object must be a one-dimensional self-relation to be used as a weight for AGGREGATE.
  • ora-12902 : default temporary tablespace must be SYSTEM or of TEMPORARY type
  • ora-13190 : recursive SQL fetch failed
  • ora-00224 : control file resize attempted with illegal record type (string)
  • ora-28655 : Alter table add overflow syntax error
  • ora-36610 : (XSLMS00) Unable to locate a message file for OLAP message: value
  • ora-00471 : DBWR process terminated with error
  • ora-13869 : Instance-wide SQL tracing on instance string is already enabled
  • ora-00214 : control file 'string' version string inconsistent with file 'string' version string
  • ora-09201 : sfcopy: error copying file
  • ora-02878 : sou2o: Variable smpdidini overwritten
  • ora-07482 : snlmini: cannot create lock manager instance.
  • ora-06251 : NETNTT: cannot translate address file name
  • ora-30036 : unable to extend segment by string in undo tablespace 'string'
  • ora-10575 : Give up restoring recovered datafiles to consistent state: out of memory
  • 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.