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 : 23-04-2017
ORA-22306

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

  • ora-13188 : cell decode failed
  • ora-01285 : error reading file string
  • ora-12052 : cannot fast refresh materialized view string.string
  • ora-31167 : XML nodes over 64K in size cannot be inserted
  • ora-02422 : missing or invalid schema element
  • ora-28575 : unable to open RPC connection to external procedure agent
  • ora-15013 : diskgroup "string" is already mounted
  • ora-25126 : Invalid name specified for BUFFER_POOL
  • ora-38774 : cannot disable media recovery - flashback database is enabled
  • ora-30162 : The OCIFile context is not initialzed
  • ora-30024 : Invalid specification for CREATE UNDO TABLESPACE
  • ora-24058 : cannot downgrade QUEUE_TABLE that has propagation in a prepared state
  • ora-30390 : the source statement is not equivalent to the destination statement
  • ora-10704 : Print out information about what enqueues are being obtained
  • ora-39092 : unable to set SCN metadata for object "string.string" of type string
  • ora-23532 : tables with different synchronization mechanisms are in the same group
  • ora-27162 : thread creation failed
  • ora-22855 : optional name for LOB storage segment incorrectly specified
  • ora-19010 : Cannot insert XML fragments
  • ora-16557 : the database is already in use
  • ora-23434 : master site string not known for object group
  • ora-10560 : block type 'string'
  • ora-30381 : REWRITE_TABLE is not compatible with Oracle version
  • ora-01906 : BACKUP keyword expected
  • ora-12065 : unknown refresh group identifier string
  • ora-12054 : cannot set the ON COMMIT refresh attribute for the materialized view
  • ora-14458 : attempt was made to create a temporary table with INDEX organization
  • ora-25280 : complete sender information not provided to non-repudiate sender
  • ora-15113 : alias name 'string' refers to a directory
  • ora-02798 : Invalid number of requests
  • 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.