SQL*Loader - what happened?

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 Mon Apr 07 2003 - 17:56:02 CEST