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 : 26-04-2017

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

  • ora-10284 : simulate zero/infinite asynch I/O buffering
  • ora-37177 : column string does not have any leaf values
  • ora-32120 : Buffer size is less than amount specified
  • ora-23377 : bad name string for missing_rows_oname1 argument
  • ora-38493 : feature not enabled : Expression Filter index
  • ora-27065 : cannot perform async vector I/O to file
  • ora-13205 : internal error while parsing spatial parameters
  • ora-15185 : Could not close dynamic library string, error [string]
  • ora-23300 : %s
  • ora-22278 : must update the LOB only through the LOB buffers
  • ora-02379 : profile string already exists
  • ora-02422 : missing or invalid schema element
  • ora-10948 : trace name context forever
  • ora-30351 : query rewrite does not currently support this expression
  • ora-12645 : Parameter does not exist.
  • ora-39038 : Object path "string" is not supported for string jobs.
  • ora-23485 : Column group "string" must consist of a single numeric column only
  • ora-25238 : too many recipients specified for message destination string
  • ora-02710 : osnpop: fork failed
  • ora-21611 : key length [string] is invalid
  • ora-01799 : a column may not be outer-joined to a subquery
  • ora-02038 : define is not allowed for array type
  • ora-38777 : database must not be started in any other instance.
  • ora-28611 : bitmap index is corrupted - see trace file for diagnostics
  • ora-06752 : TLI: error in signal setup
  • ora-00114 : missing value for system parameter SERVICE_NAMES
  • ora-22804 : remote operations not permitted on object tables or user-defined type columns
  • ora-12555 : TNS:permission denied
  • ora-33016 : (XSAGDNGL07) In AGGMAP workspace object, workspace object is not a valid operator or variable name.
  • ora-13217 : invalid parameters supplied in ALTER INDEX statement
  • 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.