Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I was wondering if there was a way I can execute a SQL Loader script from SQL Plus.

We are using Oracle 10g.

share|improve this question
up vote 6 down vote accepted

An alternative technique may be to use an external table. There is no need to take your CSV (or whatever) file and load it in a separate step. Simply declare your external table in the correct format (this is almost identical to a SQL*Loader parfile, but wrapped in a CREATE TABLE statement) and you can issue a SELECT directly against it, once the file is in the right place. It will create .BAD and .LOG files, just like SQL*Loader for any records that can't be cast to the datatypes in the table. You could expect better performance too. These days I would consider SQL*Loader to be for legacy apps only.

share|improve this answer
Just found out that this approach won't work for loading (C)LOBs. I guess I'll give @BenV's suggestion a try ... – Thomas Jung Jan 8 at 22:12

You should be able to run it via the HOST command:

SQL> host /path/to/ora/bin/sqlldr parfile=...
share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.