regarding sqlloader [message #23315] |
Sat, 30 November 2002 01:09 |
akularaju
Messages: 6 Registered: July 2002
|
Junior Member |
|
|
Hi,
Regarding sqlloader.My text file named loader.txt contains this code.
load data infile '150522_2511132002list.txt'
into table temp fields terminated by "," ENCLOSED BY '"' TRAILING NULLCOLS (field1,field2)
and in the 150522_2511132002list.txt file contains
8,95,735 records separated by commas
at command prompt I issued this command
sqlldr scott/tiger loader.txt
When this statement is executed I am getting only 27,378 records in the table temp.
ActuallyI should get 8,95,735.
I dont know y it is happening?
Can anybody tell me.
thanx in advance
regards,
RajAkula
|
|
|
Re: regarding sqlloader [message #23320 is a reply to message #23315] |
Sun, 01 December 2002 06:28 |
|
Mahesh Rajendran
Messages: 10707 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
1. delete truncate the records from loader ( loader by previous session).
2. load again using
sqlldr userid=user/pass control=loader.txt log=loader.log
3. open the loader.log and see, why those records are rejected.
4. pls post the exact error message found.
|
|
|