ORA-24181: The type string does not exist

Cause : The soruce or edstinatoin typef or thet ransfomration odes note xist

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

Createt he typ eor speicfy onet hat exsits

update : 30-04-2017

ORA-24181 - The type string does not exist
ORA-24181 - The type string does not exist

  • ora-38771 : unnamed datafile(s) added to control file by flashback recovery
  • ora-09300 : osncon: unable to connect, DPMI not available
  • ora-13463 : error retrieving GeoRaster data: string
  • ora-29868 : cannot issue DDL on a domain index marked as LOADING
  • ora-32144 : Cannot perform operation on a null interval
  • ora-39785 : SQL expressions returning ADT objects are not allowed in direct path
  • ora-29900 : operator binding does not exist
  • ora-02374 : conversion error loading table string.string
  • ora-16237 : SGA specified for Logical Standby is too small
  • ora-22955 : The cardinality parameter is not within the allowed limits
  • ora-29952 : cannot issue DDL on a domain index partition marked as LOADING
  • ora-16216 : Log stream sequence error
  • ora-02172 : The PUBLIC keyword is not appropriate for a disable thread
  • ora-16130 : supplemental log information is missing from log stream
  • ora-06559 : wrong datatype requested, string, actual datatype is string
  • ora-14048 : a partition maintenance operation may not be combined with other operations
  • ora-30370 : set operators are not supported in this context
  • ora-06449 : The list IO or the sysvendor is not installed.
  • ora-23304 : malformed deferred rpc at arg string of string in call string, in tid string
  • ora-01865 : not a valid era
  • ora-07486 : scg_get_inst: cannot convert(get) instance number lock.
  • ora-28358 : improper set key syntax
  • ora-19687 : SPFILE not found in backup set
  • ora-28012 : Manual commit not allowed here
  • ora-02283 : cannot alter starting sequence number
  • ora-02297 : cannot disable constraint (string.string) - dependencies exist
  • ora-33218 : (CINSERT04) %K is not a valid value for the workspace object dimension. Values for this dimension can have at most number significant digits after rounding to number decimal places.
  • ora-02396 : exceeded maximum idle time, please connect again
  • ora-00326 : log begins at change string, need earlier change string
  • ora-12843 : pdml lock not held properly on the table
  • 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.