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 : 24-05-2017
ORA-02374

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

  • ora-25264 : cant get signature for this queue
  • ora-37039 : (XSMLTDCL05) You cannot maintain triggers in analytic workspace string because it is attached in MULTI mode.
  • ora-32139 : Cannot write to the stream
  • ora-12091 : cannot online redefine table "string"."string" with materialized views
  • ora-01188 : Block size string in header does not match physical block size string
  • ora-31450 : invalid value for change_table_name
  • ora-01754 : a table may contain only one column of type LONG
  • ora-23309 : object string.string of type string exists
  • ora-30337 : multiple JOIN KEY clauses specified for the same parent level
  • ora-00361 : cannot remove last log member string for group string
  • ora-19633 : control file record string is out of sync with recovery catalog
  • ora-16757 : resource guard could not get property
  • ora-06902 : CMX: cannot attach to cmx subsystem
  • ora-08344 : srapp: failed to send redo data to the redo server
  • ora-00962 : too many group-by / order-by expressions
  • ora-26097 : unsupported conversion for column string (from type number to type number)
  • ora-07273 : sppst: invalid semaphore id.
  • ora-12161 : TNS:internal error: partial data received
  • ora-19259 : XQ0039 - duplicate parameter name string in function declaration
  • ora-31055 : A null XMLType element cannot be inserted into RESOURCE_VIEW
  • ora-07572 : szrfc: insufficient rolename buffer space
  • ora-32838 : exceeded maximum number of properties
  • ora-08232 : smsdes: cannot detach from SGA
  • ora-01031 : insufficient privileges
  • ora-37603 : (XSPGERRTEMPSYSTEM) Ran out of temporary storage while writing to a system temporary analytic workspace. Free some temporary storage immediately. You can do so, for example, by DETACHING an analytic workspace.
  • ora-28357 : password required to open the wallet
  • ora-34360 : (MXDSS15) number other users writing
  • ora-14609 : Tablespace was not specified for the previous lob segments of column string in template but is specified for string
  • ora-24055 : cannot delete propagation status rows that are in prepared state
  • ora-06433 : ssaio: LSEEK error, unable to seek to requested block.
  • 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.