blocks|key|3449441|text|安装oracle客户端软件。(速成版不包括sqlldr.exe)|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3449442|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Install the oracle client software. (Express edition does not include sqlldr.exe)

blocks|key|513029|text|使用以下链接下载Windows+version+wise所需的所有安装。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|513030|http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html|offset|length|513031|(指定此安装是有原因的。它为您提供了与oracle相关的各种软件、即时客户端或实用程序。文件很大，在我的例子中几乎是1.2+GB。)|513032|选择windows安装的适当版本。你应该有一个帐户来下载这个，如果你没有，请在你选择合适的下载时创建一个帐户。|513033|setup.exe|style|BOLD|513034|Select数据库解压，然后单击作为custom|unordered-list-item|513035|
|513036|"Use+内置帐户的setup.exe|513037|Select安装类型“主目录用户选择的帐户选项。|ordered-list-item|513038|根据您的requirement.|513039|From+组件名称选择安装位置。请在installation|513040|Open命令提示符下选择SQLLDR+，然后键入它将为您提供有关其版本和可接受参数的详细信息。|513041|513042|513043|希望这能有所帮助。|513044|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|2A|0|0|0|0|0|9|0|I|6|0|0|0|J|0|0|B|0|0|5|P|0|0|1B|0|0|0|0|9|0^^$0|@$1|2|3|4|5|6|7|1E|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1F|8|@]|9|@$D|1G|E|1H|1|1I]]|A|$]]|$1|F|3|G|5|6|7|1J|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|1K|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|1L|8|@$D|1M|E|1N|L|M]]|9|@]|A|$]]|$1|N|3|O|5|P|7|1O|8|@$D|1P|E|1Q|L|M]]|9|@]|A|$]]|$1|Q|3|R|5|6|7|1R|8|@]|9|@]|A|$]]|$1|S|3|T|5|P|7|1S|8|@$D|1T|E|1U|L|M]]|9|@]|A|$]]|$1|U|3|V|5|W|7|1V|8|@$D|1W|E|1X|L|M]]|9|@]|A|$]]|$1|X|3|Y|5|W|7|1Y|8|@]|9|@]|A|$]]|$1|Z|3|10|5|W|7|1Z|8|@$D|20|E|21|L|M]]|9|@]|A|$]]|$1|11|3|12|5|W|7|22|8|@$D|23|E|24|L|M]]|9|@]|A|$]]|$1|13|3|-4|5|6|7|25|8|@]|9|@]|A|$]]|$1|14|3|-4|5|6|7|26|8|@]|9|@]|A|$]]|$1|15|3|16|5|6|7|27|8|@$D|28|E|29|L|M]]|9|@]|A|$]]|$1|17|3|-4|5|6|7|2A|8|@]|9|@]|A|$]]]|18|$19|$5|1A|1B|1C|A|$1D|C]]]]

Use following link to download all installations required for Windows version wise.

<a href="http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html" rel="nofollow noreferrer">http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html</a>

(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.)

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.

<ol>
<li>Unzip and click on setup.exe</li>
<li>Select Type of installation as custom</li>
<li>"Use Windows built-in Account" Account option for Oracle Home user Selection Step.</li>
<li>Select Installation Location as per your requirement.</li>
<li>From Component Name please select Oracle Database Utilities</li>
<li>Complete the installation</li>
<li>Open command prompt and type SQLLDR it should give you detailed information about its version and acceptable parameters.</li>
</ol>

Hope this helps.

blocks|key|3449516|text|安装Oracle+Instant+Client+'tools‘包，它现在是includes+SQL*Loader。即时客户端是一个小的，免费下载，比一个完整的数据库更容易安装。您应该能够使用最近的(即.连接到Oracle+11g+DB的SQL*Loader的最新版本，因为大多数Oracle工具允许跨版本互操作性(数据泵是个例外)。Instant+Client+download+page(s)上有安装说明。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|3449517|您需要Basic+(或Basic+Light)包以及匹配的工具包。两个都解压。这与您的ODAC安装完全不同。只需设置解压到的目录的路径即可。如果全局更改路径与ODAC冲突，则只需在每次运行SQL*Loader之前在命令窗口中设置PATH即可。这也可以在批处理文件中完成。|3449518|entityMap|0|LINK|mutability|MUTABLE|url|https://blogs.oracle.com/opal/oracle-instant-client-122-now-has-sqlloader-and-data-pump|1|https://www.oracle.com/database/technologies/instant-client/downloads.html^0|11|J|0|4M|V|1|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@$A|Q|B|R|1|S]|$A|T|B|U|1|V]]|C|$]]|$1|D|3|E|5|6|7|W|8|@]|9|@]|C|$]]|$1|F|3|-4|5|6|7|X|8|@]|9|@]|C|$]]]|G|$H|$5|I|J|K|C|$L|M]]|N|$5|I|J|K|C|$L|O]]]]

Install the Oracle Instant Client 'tools' packages which now <a href="https://blogs.oracle.com/opal/oracle-instant-client-122-now-has-sqlloader-and-data-pump" rel="nofollow noreferrer">includes SQL*Loader</a>. 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 <a href="https://www.oracle.com/database/technologies/instant-client/downloads.html" rel="nofollow noreferrer">Instant Client download page(s)</a>. 

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.

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.

SQL loader installation

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

安装了Oracle Data Access Components(ODAC) for windows后，如何安装SQL Loader？我使用的是oracle DB 11gR2和oracle ODAC版本: 11.2.0.3。

问SQL加载器安装
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问SQL加载器安装EN