My control file for the sql *Loader is ass follows:
append into table a_list_tbl
fields terminated by ","
d_datetime date "dd-mon-yyyy hh24:mi:ss",
a_date date "dd-mon-yyyy hh24:mi:ss",
c_date date "dd-mon-yyyy hh24:mi:ss"
The .dat file is as under:
123456789012345,30-apr-2001 08:10:20,N1234567,30-apr-2001 08:10:20,30-apr-2001 08:10:20
When I use the Data Manager from the enterprise manager, the loading takes place successfully, however, when I try to run the same thing from the server directly, i get the following message:
control = /usr/users/mk/alist.ctl
SQL*Loader: Release 220.127.116.11.0 - Production on Mon Apr 30 11:51:22 2001
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Commit point reached - logical record count 2
What does the above mean , and how do I set it right so that loading is successful?
Everything is fine. Your SQL*Loader has successfully loaded data from your .DAT file into the database. The message "Commit point reached - logical record count 2" simply acknowledges the success of SQL*Loader.
But, when I select from the table, the new data is not returned. I therefore think, the data is not loaded. Any suggestions?
Just checkout in .BAD file. All rejected data are dumped into the .BAD file. It is possible that oracle might have rejected all of your data and dumped into .BAD file.
Yes, I checked up the .bad file. It just has the data which is not loaded. But, how do I set it right? The data is good because, when I try to lad the same thing through Data Manager, it works correctly.
Click Here to Expand Forum to Full Width