Data Pump Import Fails ORA-39083 and ORA-01722 When Table Separator Defaults are Different From Database Default NLS_NUMERIC_CHARACTERS (Doc ID 1072963.1)

Last updated on MARCH 11, 2010

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.4 to 10.2.0.4 - Release: 10.2 to 10.2
Information in this document applies to any platform.

Symptoms

While performing a Data Pump import (IMPDP) of a table that uses the NLS_NUMERIC_CHARACTERS settings as ',.' for the group separator and decimal character, the import of this table will fail with errors.

For example:
ORA-39083: Object type TABLE failed to create with error:
ORA-01722: invalid number
Failing sql is:
CREATE TABLE "USER"."MYTAB" ("OID" VARCHAR2(36) DEFAULT null NOT NULL ENABLE, "TIMESTAMP" VARCHAR2(20) DEFAULT null NOT NULL ENABLE, "GAL" VARCHAR2(36) DEFAULT null NOT NULL ENABLE, "AGEJEUNE" NUMBER(2,0) DEFAULT '25' NOT NULL ENABLE, "TMPSPARTIELMIN" NUMBER(4,2) DEFAULT '20,00' NOT NULL ENABLE, "TMPSPARTIELMAX" NUMBER(4,2) DEFAULT '30,00' NOT NULL ENABLE, "MAXTRDUREEABS" NUMBER(2,0)


Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms