Re: 01400, 00000, "mandatory (NOT NULL) column is missing or NULL during insert

Home -> Community -> Usenet -> c.d.o.server -> Re: 01400, 00000, "mandatory (NOT NULL) column is missing or NULL during insert

From: Peter Rak <prak_at_vsz.sk>
Date: 1997/11/26
Message-ID: <347BE3B3.B8B58478@vsz.sk>#1/1

Hi all,
Very good question.
I have sometimes the same problem.

                Peter

ltost_at_pobox.com wrote:

> WHY doesn't this error message report WHICH column is invalid? I'm
> loading many tables (each containing many columns) with SQL*Loader and
> i'm not about to go through and change all of the not null constraints to
> named not null constraints. Is there ANY way to get this info?!
>
> Thanks
> ltost_at_systemautomation.com
>
> -------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet
Received on Wed Nov 26 1997 - 00:00:00 CST