| error while using sqlldr [message #191476] |
Wed, 06 September 2006 08:52  |
rampratap
Messages: 50
Registered: November 2004
Location: New Delhi
|
Member |
|
|
Hi,
My control file is :
options(direct=true)
load data
infile 'd:\utl_dir\emp2.txt'
badfile 'd:\utl_dir\employees.bad'
discardfile 'd:\utl_dir\employees.dsc'
into table employees1
fields terminated by "|"
trailing nullcols
(employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary,
commission_pct, manager_id, department_id)
when I issue : sqlldr scott/tiger@orcl control=d:\utl_dir\employees.ctl
I get message LOgical record count 5000
and no data inserted in employees1 table.
One month back this code was running fine .
Please Help me.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
