Home » SQL » How to Run SQL Loader From Windows Command Prompt

How to Run SQL Loader From Windows Command Prompt

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.