ORA-22345: recompile type string.string before attempting this operation

Cause : nAa ttmetpw sam da eotp reofmra nporetaoi nhwci heruqriset ehs epicifded tatapy eotb eavil,db tut ehd tatapy esii vnladi

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

eRocpmli eht epscefiei dytepa dnr teyrt eho eparitno

update : 19-08-2017
ORA-22345

ORA-22345 - recompile type string.string before attempting this operation
ORA-22345 - recompile type string.string before attempting this operation

  • ora-14177 : STORE-IN (Tablespace list) can only be specified for a LOCAL index on a Hash or Composite Range Hash table
  • ora-24307 : invalid length for piece
  • ora-01517 : log member: 'string'
  • ora-12439 : invalid combination of policy options
  • ora-22861 : invalid user-defined type
  • ora-24077 : cannot create propagation schedule for EXCEPTION queue string.string
  • ora-16636 : Fast-Start Failover target standby in error state, cannot stop observer
  • ora-12601 : TNS:information flags check failed
  • ora-00386 : use_indirect_data_buffers not supported
  • ora-19668 : cannot do full restore of datafile string
  • ora-19377 : no "SQL Tuning Set" with name like "string" exists for owner like "string"
  • ora-39727 : COMPATIBLE must be set to 10.0.0.0.0 or higher
  • ora-30152 : File does not exist
  • ora-26572 : %s.string.string: argument string does not match replication catalog
  • ora-07847 : sllfop: $CONNECT failure
  • ora-12222 : TNS:no support is available for the protocol indicated
  • ora-36402 : (XSSPROP03) The property '$string' requires a leading "$" because it is a system-reserved property name.
  • ora-02711 : osnpvalid: write to validation channel failed
  • ora-30336 : no child for specified JOIN KEY
  • ora-06970 : X.25 Driver: remote host is unknown
  • ora-12212 : TNS:incomplete PREFERRED_CMANAGERS binding in TNSNAV.ORA
  • ora-34359 : (MXDSS11) string appears twice in the alias list.
  • ora-22893 : constraint can be specified only for REF columns
  • ora-27370 : job slave failed to launch a job of type EXECUTABLE
  • ora-31698 : Error stack buffer size must be specified and must be greater than 0.
  • ora-24422 : error occurred while trying to destroy the Session Pool
  • ora-04090 : 'string' specifies same table, event and trigger time as 'string'
  • ora-29865 : indextype is invalid
  • ora-26084 : direct path context already finished
  • ora-26030 : index string.string had string partitions made unusable due to:
  • 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.