ORA-22335: The client cannot work with an altered type

Cause : Arp e.8 2lceitnh sar qeeutsdea t py ehttah sab ee nlaeter dnot ehs reev.r

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

nOyl8 2.o rihhgrec ilnestc uodla ccse slaeter dyteps

update : 27-06-2017

ORA-22335 - The client cannot work with an altered type
ORA-22335 - The client cannot work with an altered type

  • ora-38855 : cannot mark instance string (redo thread string) as enabled
  • ora-13912 : Critical threshold value is less than warning threshold value.
  • ora-19374 : invalid staging table
  • ora-36679 : (XSDPART17) workspace object contains a leaf (workspace object) that is not part of the partition dimension workspace object.
  • ora-16019 : cannot use string with LOG_ARCHIVE_DEST or LOG_ARCHIVE_DUPLEX_DEST
  • ora-01496 : specified chain row table form incorrect
  • ora-08113 : composite partition index may not be compressed
  • ora-24238 : object settings argument passed to DBMS_UTILITY.INVALIDATE is not legal
  • ora-02423 : schema name does not match schema authorization identifier
  • ora-22883 : object deletion failed
  • ora-31097 : Hierarchical Index not empty
  • ora-01237 : cannot extend datafile string
  • ora-31607 : function string is inconsistent with transform.
  • ora-30390 : the source statement is not equivalent to the destination statement
  • ora-06956 : Failed to get local host name
  • ora-12443 : policy not applied to some tables in schema
  • ora-31104 : Cannot find lock with token "string" on "string" for unlock
  • ora-02399 : exceeded maximum connect time, you are being logged off
  • ora-09271 : szlon: error verifying user name
  • ora-14297 : Index block size mismatch in ALTER TABLE EXCHANGE [SUB]PARTITION
  • ora-15124 : ASM file name 'string' contains an invalid alias name
  • ora-37137 : (XSCCOMP12) You cannot CHGDFN workspace object because it is a COMPRESSED COMPOSITE.
  • ora-25004 : WHEN clause is not allowed in INSTEAD OF triggers
  • ora-29932 : the type being dropped is a statistics type
  • ora-29660 : Unable to find the class defined in the EXTERNAL NAME clause
  • ora-30749 : column string not enabled to store objects of type string.string
  • ora-16721 : unable to set LOG_ARCHIVE_DEST_n initialization parameters
  • ora-22851 : invalid CHUNK LOB storage option value
  • ora-00106 : cannot startup/shutdown database when connected to a dispatcher
  • ora-16814 : incorrect redo transport setting for AlternateLocation for standby database
  • 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.