Re: SQL*Loader - what happened?

From: nobody <nobody_at_nowhere.com>
Date: Mon, 07 Apr 2003 22:24:00 GMT
Message-ID: <4Umka.53683$az1.50206_at_news01.bloor.is.net.cable.rogers.com>


look at the .log file it will tell you why the records were rejected.

It probably stopped at 50, as this is the default errors I believe.

"Monica Roman" <monicaroman_at_yahoo.com> wrote in message news:9eb77af5.0304070756.7b51e212_at_posting.google.com...
> Hello,
> I am brand new to Oracle...took some classes but none taught me how to
> use SQL*Loader but I've been reading everything that I can including
> many (MANY) postings here and was able to understand what to do. So I
> ran my .ctl file and it seemed that it worked, except that when I
> Select From in SQL*Plus nothing shows. Please help? I am using Oracle
> Personal Server 9i Release 9.2.0.2.0
>
> Here is what I am working with:
>
> I issued this command:
> sqlldr scott/tiger control=c:\docs\ctlfile log=file_oralog
> data=c:\docs\file.txt
>
> ctlfile.ctl looks like this:
>
> Load Data
> INFILE 'C:\DOCS\file.txt'
> APPEND INTO TABLE tablex
> FIELDS TERMINATED BY ','
> (TBLDATE, TBLPRIORITY, TBLCODE, TBLTEXT)
>
> the file.txt looks like this:
>
> 2003-04-07 08:59:15,Priority6.Save,44.55.66.00,%NUMBER1: lots of text:
> lots of more text: and more text "text"
> 2003-04-07 08:59:16,Priority5.Run,88.99.76.9,%NUMBER7: lots of text:
> lots of more text: and more text "text"/ and a little more text
> 2003-04-07 08:59:17,Priority4.Delete,77.79.43.05,%NUMBER2: lots of
> text: lots of more text: and more text22
>
> etc.
>
> The command prompt message said:
>
> "commit point reached - logical record count 64"
>
> It put 64 lines in a .bad file and ignored more than 1000 lines in the
> .txt file.
>
> Where did I go wrong?
>
> Thank you much for your help!!
>
> Monica Roman
Received on Tue Apr 08 2003 - 00:24:00 CEST

Original text of this message