How to Run SQL Loader From Windows Command Prompt

Written by
Vinish Kapoor is a seasoned software development professional and a fervent enthusiast of artificial intelligence (AI). His impressive career spans over 20 years, marked by a relentless pursuit of innovation and excellence in the field of information technology. As an Oracle ACE, Vinish has distinguished himself as a leading expert in Oracle technologies, a title awarded to individuals who have demonstrated their deep commitment, leadership, and expertise in the Oracle community.
  • SQL
  • 1 min read

In Windows, you can run SQL loader from command prompt via the following ways:

1. Command Line Reference

sqlldr scott/tiger@orcl data=C:\data\emp.csv control=c:\ctl\empctl.ctl log=c:\temp\sqllog.log

Output

SQL*Loader: Release 11.1.0.7.0 - Production on Mon Jul 9 14:48:54 2018

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

Commit point reached - logical record count 14

2. Using batch script

Save the above sqlldr command in the batch file with extension .bat.  and execute it by typing batch file name.