Thanks for the reply.
I tried this but still it is generating logs.
Below is the sample of my parfile and also I have set the table to nologging.
userid=ofus/ofus@orcl8i
control=loaddata.ctl
errors=25000
direct=true
log=loaddata.log
Also when reading the documentation I saw
"To use a direct path load (with the exception of parallel loads), SQL*Loader must have exclusive write access to the table and exclusive read/write access to any indexes"
How do you make sure of this and what are its implications.
Thanks
Anurag
Appreciation is a wonderful thing;
It makes what is excellent in others belong to us as well.