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 : 20-08-2017
ORA-02374

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

  • ora-00023 : session references process private memory; cannot detach session
  • ora-39778 : the parallel load option is not allowed when loading lob columns
  • ora-00344 : unable to re-create online log 'string'
  • ora-26763 : invalid file type "string"
  • ora-33468 : (ESDREAD13) Discarding compiled code for workspace object because number is no longer a surrogate of dimension workspace object.
  • ora-01970 : You must specify a database name for CREATE CONTROLFILE
  • ora-34181 : (MXCHGDCL21) workspace object is not a partitioned VARIABLE.
  • ora-02284 : duplicate INCREMENT BY specifications
  • ora-37139 : (XSCCOMP14) Cannot AGGREGATE workspace object using AGGMAP workspace object because you can not AGGREGATE a variable dimensioned by a COMPRESSED COMPOSITE using an AGGMAP with a PROTECT clause.
  • ora-31517 : CDC change table string.string already exists
  • ora-24057 : cannot define subscriber with rule for queue string
  • ora-16643 : unable to determine location of broker configuration files
  • ora-39099 : cannot create index for "string" on master table string
  • ora-36847 : (XSLMGEN17) AW name is blank
  • ora-09814 : Unable to expand file name
  • ora-37043 : (XSACQUIRE_DEP_OLDGEN) Composite, concat, dimension map, or internal partition workspace object cannot be locked since another user has committed a new one already.
  • ora-29288 : invalid file name
  • ora-19723 : Cannot recreate plugged in read-only datafile string
  • ora-14028 : missing AT or VALUES keyword
  • ora-00393 : log string of thread string is needed for recovery of offline datafiles
  • ora-09812 : Unable to get user clearance from connection
  • ora-30556 : functional index is defined on the column to be modified
  • ora-24065 : propagation for QUEUE string and DESTINATION string already disabled
  • ora-02084 : database name is missing a component
  • ora-04076 : invalid NEW or OLD specification
  • ora-03288 : both FREELIST GROUP and INSTANCE parameters may not be specified
  • ora-02080 : database link is in use
  • ora-22344 : can not specify CONVERT TO SUBSTITUTABLE option for ALTER TYPE other than NOT FINAL change
  • ora-30105 : 'string' is not a legal boolean for 'string'
  • ora-07670 : $IDTOASC failed translating a secrecy category
  • 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.