ORA-22306: type "string"."string" already exists

Cause : Theu seri s tyringt o ceratea tyep thta aleradye xisst.

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

Chekc tom akes uret hatt he ytpe ahs nto bene craetedp rio rto htis.

update : 26-07-2017
ORA-22306

ORA-22306 - type "string"."string" already exists
ORA-22306 - type "string"."string" already exists

  • ora-12217 : TNS:could not contact PREFERRED_CMANAGERS in TNSNAV.ORA
  • ora-19202 : Error occurred in XML processingstring
  • ora-01554 : out of transaction slots in transaction tables
  • ora-31022 : Element not found
  • ora-02882 : sou2o: Could not register SGA for protection
  • ora-07561 : szprv: $IDTOASC failure
  • ora-32615 : incorrect use of MODEL IS ANY predicate
  • ora-02832 : Segment deallocation failed - segment not on list
  • ora-32631 : illegal use of objects in MODEL
  • ora-36674 : (XSDPART12) Invalid dimension value starting at string.
  • ora-19626 : backup set type is string - can not be processed by this conversation
  • ora-29369 : invalid method name string specified for consumer group string
  • ora-36902 : (XSAGDNGL43) In AGGMAP workspace object, the MODEL workspace object is not a model over a base dimension of the AGGMAP.
  • ora-29279 : SMTP permanent error: string
  • ora-02758 : Allocation of internal array failed
  • ora-15018 : diskgroup cannot be created
  • ora-09846 : soacon: ARCH unable to open named pipe.
  • ora-35276 : (SNSYN163) The format of the ALLOCATE command is: ALLOCATE varname [SOURCE svarname] [BASIS bvarname [ACROSS dimname]] [TARGET tvarname [TARGETLOG logvarname]] [ USING aggmap ]
  • ora-32620 : illegal subquery within MODEL rules
  • ora-36728 : (XSALERR01) While performing the ALLOCATE command with AGGMAP workspace object, the error logging limit of number was exceeded.
  • ora-02055 : distributed update operation failed; rollback required
  • ora-02263 : need to specify the datatype for this column
  • ora-12831 : Must COMMIT or ROLLBACK after executing INSERT with APPEND hint
  • ora-31411 : change set string is referenced by a change table
  • ora-02842 : Client unable to fork a server
  • ora-28039 : cannot validate Kerberos service ticket
  • ora-12654 : Authentication conversion failed
  • ora-12675 : External user name not available yet
  • ora-01725 : USERENV('COMMITSCN') not allowed here
  • ora-02446 : CREATE TABLE ... AS SELECT failed - check constraint violated
  • 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.