How To Install Sql Loader
It's sort of possible to add SQL*Loader to Instant Client, apparently - I haven't tried and am not advocating that. But you'd need the full client anyway; you can get that from the database installer, so you might as well just use that. 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.
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.
How To Install Oracle Sql Loader
2 Answers
Use following link to download all installations required for Windows version wise.
(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.)
(this tool also has many useful diagnostic features) To configure manually, see step 5. Manual configuration can be very confusing. It is only recommended if you are knowledgeable of TCP/IP and basic Server-Client concepts. To configure with Oblivion Reborn: Complete, skip to step 6. The alternative to Manual Configuration is OR:Complete (see next step).
Select appropriate version of your windows installation. Download hyperspin full set. You should have an account to download this if you don't have please create one while you select the suitable download.
- Unzip and click on setup.exe
- Select Type of installation as custom
- 'Use Windows built-in Account' Account option for Oracle Home user Selection Step.
- Select Installation Location as per your requirement.
- From Component Name please select Oracle Database Utilities
- Complete the installation
- Open command prompt and type SQLLDR it should give you detailed information about its version and acceptable parameters.
Hope this helps.
Install the oracle client software. (Express edition does not include sqlldr.exe)