Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

share|improve this question

3 Answers 3

up vote 5 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.

share|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

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.

share|improve this answer

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

share|improve this answer

Your Answer

 
discard

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.