NOT NULL constraint & value too large during import

From: astalavista <nobody_at_nowhere.com>
Date: Mon, 27 Mar 2006 21:40:28 +0200
Message-ID: <44283faa$0$21544$626a54ce@news.free.fr>

Hi,

I tranfered a schema from 10.1 to a 10.2 database I got 2 problems I did'nt understand:

how can I have NULL value with constraints valided ?
why some value are too large in the 10.2 database ( same charset AL32UTF8 ) the original table was created with VARCHAR2(3 CHAR)

Thanks in advance ...

. . importing table "OPTCONT" 0 rows
imported
. . importing table "PARAM" 15 rows
imported
. . importing table "PARAMC" 13 rows
imported
. . importing table "PARAMJ" 9825 rows
imported
. . importing table "PARAMX" 13 rows
imported
. . importing table "PARGEN"

IMP-00019: row rejected due to ORACLE error 1400
IMP-00003: ORACLE error 1400 encountered
ORA-01400: cannot insert NULL into ("TRESOMET"."PARGEN"."PARAM")

Column 1
Column 2 CUI
Column 3
Column 4
Column 5 0
Column 6 0
Column 7
Column 8

IMP-00019: row rejected due to ORACLE error 1400
IMP-00003: ORACLE error 1400 encountered
ORA-01400: cannot insert NULL into ("TRESOMET"."PARGEN"."PARAM")

Column 1
Column 2 CUI
Column 3
Column 4
Column 5 0
Column 6 0
Column 7
Column 8

IMP-00019: row rejected due to ORACLE error 1400
IMP-00003: ORACLE error 1400 encountered
ORA-01400: cannot insert NULL into ("TRESOMET"."PARGEN"."CODMET")

Column 1
Column 2
Column 3
Column 4 CI
Column 5 0
Column 6 0
Column 7
Column 8

IMP-00019: row rejected due to ORACLE error 1400
IMP-00003: ORACLE error 1400 encountered
ORA-01400: cannot insert NULL into ("TRESOMET"."PARGEN"."PARAM")

Column 1
Column 2 COC
Column 3
Column 4
Column 5 0
Column 6 0
Column 7

Column 8           4 rows imported


. . importing table                       "PNTBRK"         30 rows

imported


. . importing table                       "PNTDEV"        132 rows

imported


. . importing table                    "POS_PRIME"        973 rows

imported


. . importing table                     "PRIMECLI"

IMP-00019: row rejected due to ORACLE error 12899

IMP-00003: ORACLE error 12899 encountered ORA-12899: value too large for column "TRESOMET"."PRIMECLI"."TYPCOU" (actual: 4,
maximum: 3)
Column 1
Column 2 NW
Column 3 01-JAN-1999:00:00:00
Column 4
Column 5 XxX
Column 6 NULL
Column 7 53

IMP-00019: row rejected due to ORACLE error 12899
IMP-00003: ORACLE error 12899 encountered
ORA-12899: value too large for column "TRESOMET"."PRIMECLI"."TYPCOU"

(actual: 4,
maximum: 3)
Column 1
Column 2 SCCC
Column 3 01-JAN-1999:00:00:00
Column 4
Column 5 XxX
Column 6 NULL
Column 7 53

IMP-00019: row rejected due to ORACLE error 12899
IMP-00003: ORACLE error 12899 encountered
ORA-12899: value too large for column "TRESOMET"."PRIMECLI"."TYPCOU"

(actual: 4,
maximum: 3)

Thierry CONSTANT
SA & DBA
NEXANS-CLICHY-FRANCE
+33-1-55-62-79-72
prestation3.exploitation_at_nexans.com Received on Mon Mar 27 2006 - 13:40:28 CST