SQL loader installation

oracle sql-loader oracleclient
N10ram picture N10ram · Mar 25, 2016 · Viewed 20.1k times · Source

How can I install the SQL Loader, when I have installed the Oracle Data Access Components(ODAC) for windows? I am using oracle DB 11gR2 and oracle ODAC version: 11.2.0.3.

Answer

Shekhar Nalawade picture Shekhar Nalawade · May 28, 2018

Use following link to download all installations required for Windows version wise.

http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html

(There is a reason to specify this installation. It gives you all sort of software,instant client or utilities associated with oracle. File size is big almost 1.2 GB in my case.)

Select appropriate version of your windows installation. You should have an account to download this if you don't have please create one while you select the suitable download.

  1. Unzip and click on setup.exe
  2. Select Type of installation as custom
  3. "Use Windows built-in Account" Account option for Oracle Home user Selection Step.
  4. Select Installation Location as per your requirement.
  5. From Component Name please select Oracle Database Utilities
  6. Complete the installation
  7. Open command prompt and type SQLLDR it should give you detailed information about its version and acceptable parameters.

Hope this helps.

Related questions

Oracle: Import CSV file

I've been searching for a while now but can't seem to find answers so here goes... I've got a CSV file that I want to import into a table in Oracle (9i/10i). Later on I plan to use this …

Read More
Oracle sqlldr TRAILING NULLCOLS required, but why?

I have an abstruse sqlldr problem that's bothering me. My control file looks something like this: load data infile 'txgen.dat' into table TRANSACTION_NEW fields terminated by "," optionally enclosed by '"' TRAILING NULLCOLS ( A, B, C, D, ID "…

Read More
Disable and later enable all table indexes in Oracle

How would I disable and later enable all indexes in a given schema/database in Oracle? Note: This is to make sqlldr run faster.

Read More