{"id":10768,"date":"2019-07-26T08:47:00","date_gmt":"2019-07-26T08:47:00","guid":{"rendered":"https:\/\/ittutorial.org\/?p=10768"},"modified":"2020-11-11T19:24:57","modified_gmt":"2020-11-11T19:24:57","slug":"sql-loader-download-install-sqlldr-how-to-oracle","status":"publish","type":"post","link":"https:\/\/ittutorial.org\/sql-loader-download-install-sqlldr-how-to-oracle\/","title":{"rendered":"How to Download and Install SQL*Loader for Oracle 12c"},"content":{"rendered":"<p>I will explain How to Download and Install SQL*Loader for Oracle 12c in this article.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10777\" src=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/07\/SQLLoader.png\" alt=\"\" width=\"607\" height=\"297\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/07\/SQLLoader.png 607w, https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/07\/SQLLoader-300x147.png 300w\" sizes=\"auto, (max-width: 607px) 100vw, 607px\" \/><\/p>\n<p><!--more--><\/p>\n<p>&nbsp;<\/p>\n<h2><span style=\"color: #ff0000;\">Download &amp; Install SQL*Loader Oracle 12c<\/span><\/h2>\n<p>SQL*Loader is very\u00a0powerful data parsing engine and loads data directly from external files into Oracle database tables.\u00a0 SQL*Loader is available with default Oracle database installation.<\/p>\n<p>&nbsp;<\/p>\n<h2><span style=\"color: #ff0000;\">SQL*Loader Install\u00a0<\/span><\/h2>\n<p>You should install\u00a0SQL*Loader at the Client Side externally if you need it.<\/p>\n<p>You should download Oracle Client on Support Oracle for installation of SQL*Loader.<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<h3><span style=\"color: #ff0000;\">SQL*Loader Download<\/span><\/h3>\n<p>Download the Oracle client from the following link.<\/p>\n<p><a href=\"https:\/\/www.oracle.com\/database\/technologies\/oracle-database-software-downloads.html\">https:\/\/www.oracle.com\/database\/technologies\/oracle-database-software-downloads.html<\/a><\/p>\n<p>Oracle Client Installation files for Windows are like following.<\/p>\n<p>&nbsp;<\/p>\n<p>Click setup.exe.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10778\" src=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/07\/SQLLoaderInstall8.jpg\" alt=\"\" width=\"1059\" height=\"322\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/07\/SQLLoaderInstall8.jpg 1059w, https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/07\/SQLLoaderInstall8-300x91.jpg 300w, https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/07\/SQLLoaderInstall8-768x234.jpg 768w, https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/07\/SQLLoaderInstall8-1024x311.jpg 1024w\" sizes=\"auto, (max-width: 1059px) 100vw, 1059px\" \/><\/p>\n<p>&nbsp;<\/p>\n\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>Choose Custom for SQL*Loader.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10769\" src=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/07\/SQLLoaderInstall1.jpg\" alt=\"\" width=\"982\" height=\"739\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/07\/SQLLoaderInstall1.jpg 982w, https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/07\/SQLLoaderInstall1-300x226.jpg 300w, https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/07\/SQLLoaderInstall1-768x578.jpg 768w\" sizes=\"auto, (max-width: 982px) 100vw, 982px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>Select Languages.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10770\" src=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/07\/SQLLoaderInstall2.jpg\" alt=\"\" width=\"979\" height=\"743\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/07\/SQLLoaderInstall2.jpg 979w, https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/07\/SQLLoaderInstall2-300x228.jpg 300w, https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/07\/SQLLoaderInstall2-768x583.jpg 768w\" sizes=\"auto, (max-width: 979px) 100vw, 979px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>Specify Windows user for Installation. I have used Windows Built in Account.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10771\" src=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/07\/SQLLoaderInstall3.jpg\" alt=\"\" width=\"982\" height=\"740\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/07\/SQLLoaderInstall3.jpg 982w, https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/07\/SQLLoaderInstall3-300x226.jpg 300w, https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/07\/SQLLoaderInstall3-768x579.jpg 768w\" sizes=\"auto, (max-width: 982px) 100vw, 982px\" \/><\/p>\n<p>&nbsp;<\/p>\n\n<p>&nbsp;<\/p>\n<p>Specify Oracle Base, Client and SQL*Loader Software Location<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10772\" src=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/07\/SQLLoaderInstall4.jpg\" alt=\"\" width=\"978\" height=\"737\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/07\/SQLLoaderInstall4.jpg 978w, https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/07\/SQLLoaderInstall4-300x226.jpg 300w, https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/07\/SQLLoaderInstall4-768x579.jpg 768w\" sizes=\"auto, (max-width: 978px) 100vw, 978px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>Select <strong>Oracle Database Utilities<\/strong> in this Step. SQL*Loader will be installed by selecting\u00a0<strong>Oracle Database Utilities.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10773\" src=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/07\/SQLLoaderInstall5.jpg\" alt=\"\" width=\"981\" height=\"739\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/07\/SQLLoaderInstall5.jpg 981w, https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/07\/SQLLoaderInstall5-300x226.jpg 300w, https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/07\/SQLLoaderInstall5-768x579.jpg 768w\" sizes=\"auto, (max-width: 981px) 100vw, 981px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>Click Install button.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10774\" src=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/07\/SQLLoaderInstall6.jpg\" alt=\"\" width=\"977\" height=\"741\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/07\/SQLLoaderInstall6.jpg 977w, https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/07\/SQLLoaderInstall6-300x228.jpg 300w, https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/07\/SQLLoaderInstall6-768x582.jpg 768w\" sizes=\"auto, (max-width: 977px) 100vw, 977px\" \/><\/p>\n\n<p>&nbsp;<\/p>\n<p>SQL*Loader Installation is completed. You can use it.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10775\" src=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/07\/SQLLoaderInstall7.jpg\" alt=\"\" width=\"980\" height=\"740\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/07\/SQLLoaderInstall7.jpg 980w, https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/07\/SQLLoaderInstall7-300x227.jpg 300w, https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/07\/SQLLoaderInstall7-768x580.jpg 768w\" sizes=\"auto, (max-width: 980px) 100vw, 980px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<h5><a href=\"https:\/\/ittutorial.org\/oracle-tutorial-oracle-database-tutorials-for-beginners-junior-oracle-dba\/\"><span style=\"color: #ff0000;\">Do you want to learn Oracle Database for Beginners, then Click and read the following articles.<\/span><\/a><\/h5>\n<p><a href=\"https:\/\/ittutorial.org\/oracle-tutorial-oracle-database-tutorials-for-beginners-junior-oracle-dba\/\" target=\"_blank\" rel=\"noopener noreferrer\">Oracle Database Tutorials for Beginners ( Junior Oracle DBA )<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>I will explain How to Download and Install SQL*Loader for Oracle 12c in this article.<\/p>\n","protected":false},"author":1,"featured_media":10777,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[5043,1994],"tags":[5582,13350,5590,5585,5583,5596,5591,13354,5589,13356,5586,13355,5588,5595,13351,5587,13349,13352,5592,5593,13353,5594,5584],"class_list":["post-10768","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-install","category-oracle","tag-download-sql-loader-for-windows-10","tag-how-to-check-sql-loader-is-installed-or-not","tag-how-to-install-sqlloader-for-oracle-12c","tag-install-expdp","tag-install-oracle-client","tag-install-sql-loader","tag-install-sqlloader-for-oracle-12c","tag-install-sqlloader-oracle-client-12c-linux","tag-oracle-data-pump-vs-sql-loader","tag-oracle-data-pump-vs-sqlloader","tag-oracle-instant-client","tag-oracle-sql-loader-license","tag-sql-loader-control-file","tag-sql-loader-install","tag-sql-loader-software-free-download","tag-sql-loader-tutorial","tag-sqlloader","tag-sqlloader-example","tag-sqlloader-for-oracle-12c","tag-sqlloader-install","tag-sqlloader-install-linux","tag-sqlloader-installation","tag-sqlldr-mac"],"aioseo_notices":[],"jetpack_featured_media_url":"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/07\/SQLLoader.png","jetpack_sharing_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/10768","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/comments?post=10768"}],"version-history":[{"count":7,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/10768\/revisions"}],"predecessor-version":[{"id":32207,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/10768\/revisions\/32207"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media\/10777"}],"wp:attachment":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media?parent=10768"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/categories?post=10768"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/tags?post=10768"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}