My Oracle Support Banner

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 FEBRUARY 03, 2019

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
  Symptoms
  Cause
  Solution
  References

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.