sql * loader

[beginnerboy]

hi to all,
I am learning oracle on my own. I have personal oracle installed in my win2k os.
I have 1600 records in my excel files . I created a table items in oracle .
I tried to export data from that excel file using sql * loader and I was able to export only 32 records and got the message like this.

Commit point reached- logical record count 42
Commit point reached- logical record count 84.

I worked as scott as well as sys. but same result. where do I need to change set up?

with best regards
niran

 

[starterbutton]

A count is kept of the number of records rejected and when that number is reached the load will terminate.

The default for this can be changed using the errors = option but until you know the reason for the records being rejected i wouldn't change it.

There should be a log file produced which will tell you why the load is failing. I think the default name is the name of the data file with a .log extension. ( Rejected records are also written to a file but have the extension .bad )

 

[THoey]

I agree that you should look at the log file. The lines you saw on the screen:

Commit point reached- logical record count 42
Commit point reached- logical record count 84.

are normal. These signify a block of records read and tried to load. They may have been successful or they may have failed. A look at the log will show something like:

Table MyTable:
2000 Rows successfully loaded.
   5 Rows not loaded due to data errors.
   0 Rows not loaded because all WHEN clauses were failed.
   0 Rows not loaded because all fields were null.

This shows you the number of records loaded and those that failed.

Terry
**************************
* General Disclaimer - Please read *
**************************
Please make sure your post is in the CORRECT forum, has a descriptive title, gives as much detail to the problem as possible, and has examples of expected results. This will enable me and others to help you faster...