5

Is it possible to install SQL*Loader without installing the whole Oracle package?

5

Yes. In the client install package, custom installation, you can select database utilities as part of the install, which should get you SQL*Loader, among other things.

3
2

the comments above were what i was looking for.

the "instant client" has sqlplus, but does not have sqlldr.

sqlldr requres the (full) "client" which is hidden off of a tiny fine print link on the craptacular oracle site.

"Oracle Database 11g Release 2 Client (11.2.0.1.0) for Microsoft Windows (32-bit)" http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win32soft-098987.html

1
  • Gosh, thank you. Took me all morning just to install that one program... at least I'm motivated because we use it to finally get away from oracle. – Mene Jul 18 '16 at 14:11
1

It seems, there is also a way to install SQL*Loader with instant clients: http://kimplove.blogspot.de/2010/08/installation-of-oracle-instant-client.html

I'm quite sure it is not supported by Oracle and you need a client installation like DCookie explained. But it could be a solution when you need to install it on multiple servers.

The alternative solution would be to make a installation like DCookie explained and create a rpm/deb from it and push it to multiple servers.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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