ORA-01722 : conversion error on import with datapump
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
----------------------------------------- -------- ----------------------------