1 Reply Latest reply: Nov 9, 2011 10:50 AM by Srini Chavali-Oracle RSS

    Import Datapump problems on Oracle 11g

    Murray Sobol
      am trying to Import (using Datapump) and DMP file from Oracle 10g (10.2.0.4).

      The 10g database server has nls_characterset of:

      SYSTEM@testers>
      PARAMETER VALUE
      ---------------------------------------------------------------- ----------------------------------------------------------------
      NLS_CHARACTERSET WE8MSWIN1252

      1 row selected.

      The 11g server has:

      SQL> select * from v$nls_parameters
      2 where parameter = upper('nls_characterset');

      PARAMETER
      ----------------------------------------------------------------
      VALUE
      ----------------------------------------------------------------
      NLS_CHARACTERSET
      AL32UTF8

      Here are the errors:

      ;;;
      Import: Release 11.2.0.2.0 - Production on Tue Nov 8 16:40:11 2011

      Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
      ;;;
      Connected to: Oracle Database 11g Release 11.2.0.2.0 - 64bit Production
      Master table "SYSTEM"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
      Starting "SYSTEM"."SYS_IMPORT_FULL_01": system/********@Testers11g DIRECTORY=impdp_dir DUMPFILE=expdpT1400.dmp REMAP_SCHEMA=t1400:t1500 LOGFILE=expdpt1500.log
      Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
      Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
      Processing object type SCHEMA_EXPORT/TABLE/TABLE
      Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
      . . imported "T1500"."DPR_OPENING_BALANCE" 172.2 MB 4537640 rows
      . . imported "T1500"."IVC_OFFSITE_OPENING_BALANCE" 199.0 MB 5120520 rows
      . . imported "T1500"."IVC_OPENING_BALANCE" 187.3 MB 5171512 rows
      . . imported "T1500"."FIN_AR_STATEMENT_SAVE" 33.73 MB 93 rows
      . . imported "T1500"."AUDIT_CONTRACT" 17.74 MB 39855 rows
      . . imported "T1500"."S1_CONTRACT_FORMAT_TEMP" 6.078 KB 2 rows
      . . imported "T1500"."FO_OPENING_BALANCE" 12.42 MB 406974 rows
      . . imported "T1500"."S1_TICKET_CHARGE_SAVE" 11.62 MB 24 rows
      . . imported "T1500"."FO_TRANSACTION_SUMMARY" 11.76 MB 406974 rows
      . . imported "T1500"."FIN_GL_ACCOUNT_BALANCE" 10.89 MB 337260 rows
      . . imported "T1500"."FIN_GL_AUDIT_TRAIL_JOURNAL" 25.48 KB 30 rows
      . . imported "T1500"."FIN_GL_AUDIT_TRAIL" 1.024 MB 6648 rows
      . . imported "T1500"."DPR_TRANSACTION_DETAIL" 5.888 MB 74588 rows
      ORA-02374: conversion error loading table "T1500"."AUDIT_RELEASE"
      ORA-12899: value too large for column SHIP_TO_SHORT_NAME (actual: 11, maximum: 10)
      ORA-02372: data for row: SHIP_TO_SHORT_NAME : 0X'C8746F696C65204C656D'


      I also tried to Import a DMP (from Export) from Oracle10g server and got this result:


      Connected to: Oracle Database 11g Release 11.2.0.2.0 - 64bit Production

      Export file created by EXPORT:V10.02.01 via conventional path
      import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
      import server uses AL32UTF8 character set (possible charset conversion)
      export client uses US7ASCII character set (possible charset conversion)
      . importing T1400's objects into T1500
      . . importing table "A1_ASYNCH_COMMUNICATION" 0 rows imported
      . . importing table "A1_BROADCAST_LOCK" 1 rows imported
      . . importing table "A1_BROADCAST_MESSAGE" 6 rows imported
      . . importing table "A1_BROADCAST_USER" 0 rows imported
      . . importing table "A1_BUILD_SCRIPT" 437 rows imported
      . . importing table "A1_DBC_APPLIED_SCRIPT" 0 rows imported
      . . importing table "A1_ERROR_HANDLER" 5880 rows imported
      . . importing table "A1_ERROR_HANDLER_COMMON" 2956 rows imported
      . . importing table "A1_ERROR_HANDLER_TITLE"
      IMP-00019: row rejected due to ORACLE error 12899
      IMP-00003: ORACLE error 12899 encountered
      ORA-12899: value too large for column "T1500"."A1_ERROR_HANDLER_TITLE"."TITLE_DESCRIPTION" (actual: 34, maximum: 32)
      Column 1 7
      Column 2 FR
      Column 3 Relâche des Fact. Récurr des CAP
      IMP-00019: row rejected due to ORACLE error 12899
      IMP-00003: ORACLE error 12899 encountered
      The errors always occur when I try to import a column containing French accented characters.

      What am I missing???