<div>
thank you very much for your help. I appreciate it.
</div>


thank you very much for your help. I appreciate it.

<div>
<div class="content wysiwyg-content">
Hi,<br />
I am loading the .csv files into oracle 10g using sqlloader using commands like<br />
<br />
sqlldr schemaname/password@IPaddr<wbr />ess:1521/o<wbr />rcl &nbsp;contrlofilename_location.c<wbr />tl ogfilename_location.log badfilename_location.log datafilenameLocation.csv<br />
<br />
But for loading some of csv files( around 500 mb of data) it is taking around 4 hours. I read some where using direct=true reduces thes time. My question is does using direct=true option along with sqlloader removes some data? or does it has any side effects? what exactly does direct=true do. Any other easy ways to improve the performance of the load. Any ideas, links, resources, syntax, code highly appreciated. Thanks in advance
</div>
</div>


Hi,
I am loading the .csv files into oracle 10g using sqlloader using commands like

sqlldr schemaname/password@IPaddress:1521/orcl  contrlofilename_location.ctl ogfilename_location.log badfilename_location.log datafilenameLocation.csv

But for loading some of csv files( around 500 mb of data) it is taking around 4 hours. I read some where using direct=true reduces thes time. My question is does using direct=true option along with sqlloader removes some data? or does it has any side effects? what exactly does direct=true do. Any other easy ways to improve the performance of the load. Any ideas, links, resources, syntax, code highly appreciated. Thanks in advance

what is the use of direct=true option in sql loader

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.