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-09-2017

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

  • ora-12911 : permanent tablespace cannot be temporary tablespace
  • ora-06746 : TLI Driver: cannot alloc t_call
  • ora-00353 : log corruption near block string change string time string
  • ora-00379 : no free buffers available in buffer pool string for block size stringK
  • ora-16513 : maximum requests exceeded
  • ora-02427 : create view failed
  • ora-31161 : element or attribute "string" cannot be stored out of line
  • ora-02282 : duplicate or conflicting ORDER/NOORDER specifications
  • ora-19239 : XP0019 - step expression must return sequence of nodes
  • ora-26518 : push queue synchronization error detected
  • ora-06807 : TLI Driver: could not open ethernet device driver file
  • ora-24760 : invalid isolation level flags
  • ora-29257 : host string unknown
  • ora-23440 : incorrect public template value
  • ora-38756 : Flashback is already turned off for this tablespace.
  • ora-10653 : Table is in a cluster
  • ora-33060 : (XSAGDNGL29) In AGGMAP workspace object, the value for the ERRORLOG MAX option must be greater than 0.
  • ora-16214 : apply stalled for apply delay
  • ora-16180 : number processes specified for MAX_PARALLEL_SERVERS is too small
  • ora-32313 : REFRESH FAST of "string"."string" unsupported after PMOPs
  • ora-15095 : reached maximum ASM file size (string GB)
  • ora-34360 : (MXDSS15) number other users writing
  • ora-28100 : policy function schema string is invalid
  • ora-06571 : Function string does not guarantee not to update database
  • ora-19323 : Invalid url string
  • ora-13007 : an invalid HEX character was detected
  • ora-16622 : two or more broker database objects resolve to one physical database
  • ora-15041 : diskgroup space exhausted
  • ora-10947 : trace name context forever
  • ora-19666 : cannot do incremental restore of the control file
  • 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.