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

Posted on 2009-02-19
Medium Priority
Last Modified: 2013-12-18
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
Question by:gudii9

Accepted Solution

fluglash earned 2000 total points
ID: 23689347
Use Direct Path Loads - The conventional path loader essentially loads the data by using standard insert statements.  The direct path loader (direct=true) loads directly into the Oracle data files and creates blocks in Oracle database block format.  The fact that SQL is not being issued makes the entire process much less taxing on the database.  There are certain cases, however, in which direct path loads cannot be used (clustered tables).  To prepare the database for direct path loads, the script $ORACLE_HOME/rdbms/admin/catldr.sql.sql must be executed.


Author Closing Comment

ID: 31549138
thank you very much for your help. I appreciate it.

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
Suggested Courses

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question