ORA-02374: conversion error loading table string.string

Cause : Ar o wcuol dnto eb olaeddi not htet albeb eacues hteer awsa ocnevriso nerro rfro noeo rm oer oclmun si nar o.w

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

See htem essaeg hta tflolwosf o rmroei noframtoina buott h erwo hta tcuol dnto eb olaedd .T oaovi dtihse rorr ,mkaes uer hted eifntiino fo htet albeb enigi mopretdm acthse hted eifntiino fo htet albeb enige xopretd.

update : 23-09-2017
ORA-02374

ORA-02374 - conversion error loading table string.string
ORA-02374 - conversion error loading table string.string

  • ora-26676 : Table 'string.string' has string columns in the LCR and string columns in the replicated site
  • ora-12456 : label security startup in progress
  • ora-32305 : RepAPI materialized views with user-defined types are not supported
  • ora-07403 : sfanfy: db_writers parameter not valid.
  • ora-19003 : Missing XML root element name
  • ora-23365 : site string does not exist
  • ora-02271 : table does not have such constraint
  • ora-01513 : invalid current time returned by operating system
  • ora-36180 : (XSAGGR08) AGGREGATE cannot function because there is a permission clause associated with variable workspace object.
  • ora-00335 : online log string: No log with this number, log does not exist
  • ora-27005 : cannot open file for async I/O on device not supporting async
  • ora-39042 : invalid transform name string
  • ora-19263 : XQ0043 - duplicate namespace prefix string
  • ora-07458 : cannot set the RESOURCE_MANAGER_PLAN parameter
  • ora-23356 : masterdef recognizes a master which does not recognize the masterdef
  • ora-00071 : process number must be between 1 and string
  • ora-02381 : cannot drop PUBLIC_DEFAULT profile
  • ora-12807 : process queue could not receive parallel query message
  • ora-02453 : duplicate HASH IS specification
  • ora-06810 : TLI Driver: could not set the IPX ethernet SAP at init
  • ora-19595 : archivelog string already included in backup conversation
  • ora-06319 : IPA: Remote maximum number of users exceeded
  • ora-02483 : Syntax error in process specification (string)
  • ora-01171 : datafile string going offline due to error advancing checkpoint
  • ora-40286 : remote operations not permitted on mining models
  • ora-30351 : query rewrite does not currently support this expression
  • ora-01502 : index 'string.string' or partition of such index is in unusable state
  • ora-01084 : invalid argument in OCI call
  • ora-14044 : only one partition may be moved
  • ora-19553 : device name string is invalid
  • 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.