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

link|improve this question

50% accept rate
feedback

3 Answers

up vote 3 down vote accepted

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.

link|improve this answer
Do you mean this: oracle.com/technology/tech/oci/instantclient/index.html I can't find SQL*Loader there. – tuler Dec 16 '09 at 18:54
No, not the instant client, you'll need to install from the full Oracle Client package. I don't think SQL*Loader will work with the instant client, so you'll need a minimal runtime oracle client install. – DCookie Dec 16 '09 at 19:24
oracle.com/technology/software/products/database/oracle10g/… is the 10gR2 client for MS Windows. – DCookie Dec 16 '09 at 19:30
feedback

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

link|improve this answer
feedback

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.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown

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