I'm a ms sql dba and I need to have sql loader installed on sql 2008 server.
I've read the posts and confused.
Will the sql loader comes with oracle client? Or it has to be installed with a server?
What's happening is that we have installed oracle client 11 64 bits and 32bits on our server. Then we found we need sql loader too. If we uninstall clients, and we download from the link for 11g client for 64 bits OS, are we going to get 64 bits client for link, 32 bits run time for BI, and sql loader?
Here is the link:
Thanks for attention.
Pl post exact versions of Oracle client and OS.
sqlldr executable is included in the client. It is unclear as to how you installed a 64-bit client on a 32-bit OS - it will not work - you will need to install a 32-bit client.