-
Hi friends,
My control file for the sql *Loader is ass follows:
LOAD DATA
INFILE 'c:alist.dat'
append into table a_list_tbl
fields terminated by ","
( a_termination,
d_datetime date "dd-mon-yyyy hh24:mi:ss",
ncode,
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:
--------------------
>sqlldr username/password
control = /usr/users/mk/alist.ctl
SQL*Loader: Release 8.1.6.0.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?
Thanks
manjunath
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|