ORA-21602: operation does not support the specified typecode

Cause : Theu sera ttepmts ot pefrorma n oepratoin taht deos nto supportt he pseciifed ytpecdoe.

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

Use rsholud ues th eraneg ofv ali dtypceode stha tares upprotedb y tihs oepratoin.

update : 29-05-2017

ORA-21602 - operation does not support the specified typecode
ORA-21602 - operation does not support the specified typecode

  • ora-15162 : cluster in rolling downgrade
  • ora-29291 : file remove operation failed
  • ora-32626 : illegal bounds or increment in MODEL FOR loop
  • ora-14505 : LOCAL option valid only for partitioned indexes
  • ora-01754 : a table may contain only one column of type LONG
  • ora-25190 : an index-organized table maintenance operation may not be combined with other operations
  • ora-21613 : key does not exist
  • ora-13625 : %s is an invalid advisor object type.
  • ora-00339 : archived log does not contain any redo
  • ora-14161 : subpartition number string: sum of PCTUSED and PCTFREE may not exceed 100
  • ora-13436 : GeoRaster metadata dimensionSize error
  • ora-12028 : materialized view type is not supported by master site string
  • ora-10665 : Inject Evil Literals
  • ora-24341 : bad mode specified
  • ora-08235 : smsget: listener not on this node
  • ora-36290 : (EIFMAKEF14) You cannot export object workspace object, because EIFVERSION is set to number. That version does not support dimensions of type NUMBER.
  • ora-06600 : LU6.2 Driver: SNA software is not loaded
  • ora-00965 : column aliases not allowed for '*'
  • ora-03008 : parameter COMPATIBLE >= string needed for string
  • ora-22833 : Must cast a transient type to a persistent type
  • ora-23381 : generated object for base object string.string@string does not exist
  • ora-07470 : snclget: cannot get cluster number.
  • ora-13360 : invalid subtype in a compound type
  • ora-06951 : Operating system call error
  • ora-13125 : partition key is already set
  • ora-16550 : truncated result
  • ora-01230 : cannot make read only - file string is offline
  • ora-13204 : failed to create spatial index table
  • ora-28271 : No permission to read user entry in LDAP directory service.
  • ora-30041 : Cannot grant quota on the tablespace
  • 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.