Re: sqlldr - detailed logging of sql stmts

From: Christoph Seidel <christoph.seidel1_at_gmx.de>
Date: Tue, 18 Mar 2003 22:48:59 +0100
Message-ID: <b58481$26eol7$1@ID-143718.news.dfncis.de>

NorwoodThree wrote:

> I'm not sure why you would need it; please clarify...
>
> sqlldr in addition to log files, creates discard and bad files.
> Anything in these types of files will show what was not loaded.

Yes, but it is difficult to find the problem quickly.

if i would have a log like:

trying: insert into t (f1,f2) values (1,2); error: bla bla

i would know what is wrong.

But with sqlldr i have to find the row in the infile, the values in the infile, have to find out what stmt sqlldr has generated and so on. This is time consuming, especially when the infile has many bug and is very large (rows and cols). Received on Tue Mar 18 2003 - 15:48:59 CST