Database Utilities (MOSC)

MOSC Banner

ORA-01722 : conversion error on import with datapump

edited May 3, 2016 9:39AM in Database Utilities (MOSC) 8 commentsAnswered ✓

I have an Oracle database server, version 11.2.0.3 on Windows

I do an export with expdp with specifying the "set NLS_LANG=FRENCH_FRANCE.AL32UTF8"

After that, I want to import this backup on Oracle database server, version 12.1.0.2 on windows.

I specifying "set NLS_LANG=FRENCH_FRANCE.AL32UTF8" before the command impdp.

I have the error below :

ORA-02374: conversion error loading table "XXXXXX"."FOO"
ORA-01722: Invalid number

ORA-02372: data for row: TESTCOL : '-~'

The foo table is defined as below, and there is only one row. The value is neg infinity.

SQL> desc FOO;
Name                                      Null?    Type
----------------------------------------- -------- ----------------------------

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center