Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL LOADER loading only one record

920624Apr 9 2012 — edited Jun 11 2012
Hi,

I'm using the SQLLOADER, and always, the SQLLOADER worked for me and loaded all the data that I pass using .csv's
But, today, I don't know why, the LOADER didn't work. I insert 1 row succesfully and the LOADER stop, didn't notice why my others line (649) is not inserted.
Can I get one way to read a full log ? or something like this ?
Because the .log is unhelpful, only show to me:

...

Table TX_MEDIA:
1 Row successfully loaded.
0 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.


Space allocated for bind array: 82560 bytes(64 rows)
Read buffer bytes: 1048576

Total logical records skipped: 0
Total logical records read: 1
Total logical records rejected: 0
Total logical records discarded: 0

Run began on Mon Apr 09 10:55:12 2012
Run ended on Mon Apr 09 10:55:13 2012

...

Thanks,
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 9 2012
Added on Apr 9 2012
11 comments
2,551 views