Home » Other » Test » ERROR WHILE EXECUTING SQLLDR
ERROR WHILE EXECUTING SQLLDR [message #188237] Thu, 17 August 2006 09:00 Go to next message
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
Re: ERROR WHILE EXECUTING SQLLDR [message #188337 is a reply to message #188237] Fri, 18 August 2006 02:19 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
Did you read my reply to your previous post??
Why post another question in the test-forum?
I am NOT going to move this one.
Re: ERROR WHILE EXECUTING SQLLDR [message #188990 is a reply to message #188237] Tue, 22 August 2006 12:36 Go to previous message
fahadsami
Messages: 31
Registered: May 2006
Member
test
Previous Topic: Test the New Topic
Next Topic: 10G new features for administrators
Goto Forum:
  


Current Time: Thu Mar 28 07:50:35 CDT 2024