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.
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)
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
|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.|