| ERROR WHILE EXECUTING SQLLDR [message #188237] |
Thu, 17 August 2006 09:00  |
vikas_miraj2003
Messages: 13
Registered: July 2006
Location: INDIA
|
Junior Member |
|
|
When typed c:\sqlldr vikas/pwd@lmserver control=c:\vikas.ctl
gives error in cmd commit point reached logical record
count 20 as 20 records r in csv file
bad file generated with ora-1722
i think it's problem of data type
in table emp_v empno is number empname varchar2
empadd varchar2 salaray number
and c:\vikas.ctl
file reads like
LOAD DATA
INFILE 'C:\mystates.csv'
REPLACE
INTO TABLE emp_v
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS
(empno,
empname,
empadd,
salary )
pl help iam at peak point
thank's in advance
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
