2 Replies Latest reply on Mar 9, 2010 5:01 PM by 653932

    ORA-02374: conversion error loading table during import using IMPDP

    653932
      HI All,

      We are trying to migrate the data from one database to an other database.

      The source database is having character set

      SQL> select value from nls_database_parameters where parameter='NLS_CHARACTERSET';

      VALUE
      ----------------------------------------
      US7ASCII


      The destination database is having character set

      SQL> select value from nls_database_parameters where parameter='NLS_CHARACTERSET';

      VALUE
      --------------------------------------------------------------------------------
      AL32UTF8

      We took an export of the whole database using expdp and when we try to import to the destination database using impdp. We are getting the following error.



      ORA-02374: conversion error loading table <TABLE_NAME>
      ORA-12899: value too large for column <COLUMN NAME> (actual: 42, maximum: 40)
      ORA-02372: data for row:<COLUMN NAME> : 0X'4944454E5449464943414349E44E204445204C4C414D414441'


      Kindly let me know how to overcome this issue in destination.

      Thanks & Regards,
      Vikas Krishna