Home » SQL & PL/SQL » SQL & PL/SQL » error while using sqlldr
error while using sqlldr [message #191476] Wed, 06 September 2006 08:52 Go to next message
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.

Re: error while using sqlldr [message #191482 is a reply to message #191476] Wed, 06 September 2006 09:15 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
It is still running fine.Smile
Please check the associated logfile. There should be some information on why the records were discarded.
Re: error while using sqlldr [message #191498 is a reply to message #191482] Wed, 06 September 2006 12:51 Go to previous message
rampratap
Messages: 50
Registered: November 2004
Location: New Delhi
Member


Hi,

Thanks Mahesh

now its working fine.

RP Singh
Previous Topic: calling function inside a procedure
Next Topic: I need Ideas
Goto Forum:
  


Current Time: Thu Dec 08 18:26:42 CST 2016

Total time taken to generate the page: 0.13620 seconds