Home » RDBMS Server » Server Utilities » ORA-02374: conversion error loading table (through Data-pump) (10g, 10.2.0.5, Windows server 2008)
ORA-02374: conversion error loading table (through Data-pump) [message #589926] Fri, 12 July 2013 01:59 Go to next message
ishika_20
Messages: 339
Registered: December 2006
Location: delhi
Senior Member
Dear All,

While importing dump to the new database, error occurred. Below are the errors -


ORA-02374: conversion error loading table "INS"."GENMST_FINANCIER_BRANCH"
ORA-12899: value too large for column TXT_IFSC_CODE (actual: 19, maximum: 15)
ORA-02372: data for row: TXT_IFSC_CODE : 0X'4644524C30303031353739A0A0A0A0'



ORA-39083: Object type REFRESH_GROUP failed to create with error:
ORA-23421: job number 24 is not a job in the job queue
Failing sql is:
 BEGIN dbms_refresh.make('"DW_REP"."DW_MV_036_COLL_LEDG_MISM"',list=>null,next_date=>null,interval=>null,
implicit_destroy=>TRUE,lax=>FALSE,job=>24,rollback_seg=>NULL,push_deferred_rpc=>TRUE,
refresh_after_errors=>FALSE,purge_option => 1,parallelism => 0,heap_size => 0);
dbms_refresh.add(name=>'"DW_REP"."DW_MV_036_COLL_LEDG_MISM"',list=>'"DW_REP"."DW_MV_036_COLL_LEDG_MISM"
ORA-39083: Object type REFRESH_GROUP failed to create with error:



ORA-39083: Object type ALTER_PROCEDURE failed to create with error:
ORA-04052: error occurred when looking up remote object CONFSYS.CNFGTR_TDE_V_FACT_DEPY@CLONE_USER
ORA-00604: error occurred at recursive SQL level 3
ORA-02019: connection description for remote database not found
Failing sql is:

ALTER PROCEDURE "CONFSYS"."INTPROC_TARIFF_REFRESH_DIFF"   COMPILE     PLSQL_OPTIMIZE_LEVEL=  2    
PLSQL_CODE_TYPE=  INTERPRETED    PLSQL_DEBUG=  FALSE REUSE SETTINGS TIMESTAMP '2013-06-26 14:09:06'



I would like to know, why such error occurred during the import. I faced such error, first time.
Please assist me to know about it.

Regards,
Ishika

[Updated on: Fri, 12 July 2013 03:12] by Moderator

Report message to a moderator

Re: ORA-02374: conversion error loading table (through Data-pump) [message #589932 is a reply to message #589926] Fri, 12 July 2013 03:10 Go to previous messageGo to next message
Michel Cadot
Messages: 60012
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-02374: conversion error loading table %*.*s.%*.*s
 *Cause: A row could not be loaded into the table because there was a
         conversion error for one or more columns in a row.
 *Action: See the message that follows for more information about the row
          that could not be loaded.  To avoid this error, make sure the
          definition of the table being imported matches the definition of
          the table being exported.

ORA-12899: value too large for column %s (actual: %s, maximum: %s)
 *Cause: An attempt was made to insert or update a column with a value
         which is too wide for the width of the destination column.
         The name of the column is given, along with the actual width
         of the value, and the maximum allowed width of the column.
         Note that widths are reported in characters if character length
         semantics are in effect for the column, otherwise widths are
         reported in bytes.
 *Action: Examine the SQL statement for correctness.  Check source
          and destination column data types.
          Either make the destination column wider, or use a subset
          of the source column (i.e. use substring).

ORA-39083: Object type %s failed to create with error:\n%s\nFailing sql is:\n%s
 *Cause:  Examine original error code to determine actual cause
 *Action: Original error code will contain more information

ORA-02019: connection description for remote database not found

What is not clear in this message?

And once again, import question MUST be posted in "Server Utilities" forum NOT in "Backup & Recovery".
And once again, just think a little bit before posting, we are not here to spoonfeed you.
What will you do when you will be no more there?

Regards
Michel

[Updated on: Fri, 12 July 2013 03:11]

Report message to a moderator

Re: ORA-02374: conversion error loading table (through Data-pump) [message #589935 is a reply to message #589932] Fri, 12 July 2013 04:35 Go to previous messageGo to next message
ishika_20
Messages: 339
Registered: December 2006
Location: delhi
Senior Member
Dear Michel,

You are correct. I also read the error messages. But what ever schema's I have exported is imported in the new database.
IMPDP will create tables and import all the datas on it then why do i get this error?

And what ever was there should import in the same manner. It should not give any error.

That's why i posted here, else i can solve it by myself only.

Thanks for your response...

Regards,
Ishika
Re: ORA-02374: conversion error loading table (through Data-pump) [message #589936 is a reply to message #589935] Fri, 12 July 2013 04:38 Go to previous messageGo to next message
cookiemonster
Messages: 11285
Registered: September 2008
Location: Rainy Manchester
Senior Member
What's the datatype of TXT_IFSC_CODE ?
Re: ORA-02374: conversion error loading table (through Data-pump) [message #589940 is a reply to message #589936] Fri, 12 July 2013 05:04 Go to previous messageGo to next message
ishika_20
Messages: 339
Registered: December 2006
Location: delhi
Senior Member
Dear Cookiemonster,

Data type is VARACHAR2(15)in both the database (source & destination).

Your next question would be, datatype max size is 15 and actual size is 19. So, oracle is pointing the correct error message only.

But data type size in source and destination is 15, then why such error occurred? Once, it saved at source side, it should smoothly import to the destination side also, as destination database created newly.

Welcome your valuable comments on this.

Regards,
Ishika
Re: ORA-02374: conversion error loading table (through Data-pump) [message #589944 is a reply to message #589940] Fri, 12 July 2013 05:43 Go to previous message
Michel Cadot
Messages: 60012
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ Character set are different
2/ BYTE <> CHAR, some characters are coded with several bytes

Regards
Michel
Previous Topic: how to add date/time in export dump file in Linux
Next Topic: geometric data from text to table and wrong ctl upload into table (2 threads merged by bb)
Goto Forum:
  


Current Time: Sun Dec 21 20:08:59 CST 2014

Total time taken to generate the page: 0.09285 seconds