oracle SQL加载器安装
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/36224999/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
SQL loader installation
提问by N10ram
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.
当我为 Windows 安装了 Oracle 数据访问组件 (ODAC) 后，如何安装 SQL 加载程序？我正在使用 oracle DB 11gR2 和 oracle ODAC 版本：11.2.0.3。
回答by Shekhar Nalawade
Use following link to download all installations required for Windows version wise.
使用以下链接下载 Windows 版本所需的所有安装。
http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html
http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html
(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.)
（指定此安装是有原因的。它为您提供了与 oracle 相关的各种软件、即时客户端或实用程序。在我的情况下，文件大小几乎为 1.2 GB。）
Select appropriate version of your windows installation. You should have an account to download this if you don't have please create one while you select the suitable download.
选择合适的 Windows 安装版本。你应该有一个帐户来下载这个，如果你没有，请在选择合适的下载时创建一个。
- 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 Nameplease 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.
- 解压并点击setup.exe
- 选择安装类型为自定义
- Oracle Home 用户选择步骤的“使用 Windows 内置帐户”帐户选项。
- 根据您的要求选择安装位置。
- 请从组件名称中选择Oracle Database Utilities
- 完成安装
- 打开命令提示符并键入 SQLLDR，它应该会为您提供有关其版本和可接受参数的详细信息。
Hope this helps.
希望这可以帮助。
回答by Christopher Jones
Install the Oracle Instant Client 'tools' packages which now includes SQL*Loader. Instant Client is a small, free download and much easier to install then a full DB. You should be able to use a recent (ie. the latest) version of SQL*Loader to connect to your Oracle 11g DB, since most Oracle tools allow cross-version interoperability (Data Pump is an exception). There are installation instructions on the Instant Client download page(s).
安装现在包含 SQL*Loader的 Oracle Instant Client“工具”包。Instant Client 是一个小的、免费的下载并且比一个完整的数据库更容易安装。您应该能够使用最新（即最新）版本的 SQL*Loader 连接到您的 Oracle 11g 数据库，因为大多数 Oracle 工具都允许跨版本互操作（数据泵是一个例外）。Instant Client 下载页面上有安装说明。
You will need the Basic (or Basic Light) package as well as the matching Tools package. Unzip both. This is totally separate to your ODAC installation. Just set PATH to the directory you unzip into. If globally changing PATH interferes with ODAC, then just set PATH in your command window each time before you run SQL*Loader. This can also be done in a batch file.
您将需要 Basic（或 Basic Light）包以及匹配的 Tools 包。解压两者。这与您的 ODAC 安装完全不同。只需将 PATH 设置为您解压到的目录即可。如果全局更改 PATH 会干扰 ODAC，那么每次运行 SQL*Loader 之前，只需在命令窗口中设置 PATH。这也可以在批处理文件中完成。
回答by Beege
Install the oracle client software. (Express edition does not include sqlldr.exe)
安装oracle客户端软件。（速成版不包含sqlldr.exe）
