[go: up one dir, main page]
Scribd
Upload
37 views3 pages

SQL Loader Guide for DBAs

The document outlines the steps to load data through SQL Loader: 1) Create the necessary files like control, data, bad, discard, and log files in the required location. 2) Create a directory in Oracle and grant read/write permissions to the user. 3) Open the command prompt and run SQL Loader specifying the control file, data file, bad file, discard file, and log file.

Uploaded by

nagkkkkk
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
37 views3 pages

SQL Loader Guide for DBAs

The document outlines the steps to load data through SQL Loader: 1) Create the necessary files like control, data, bad, discard, and log files in the required location. 2) Create a directory in Oracle and grant read/write permissions to the user. 3) Open the command prompt and run SQL Loader specifying the control file, data file, bad file, discard file, and log file.

Uploaded by

nagkkkkk
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 3

*****************How to Load Data Through Sql Loader***************

step1: we have to create files for ctrl, bad, discard, log, data files for required
location.

control file:

Data file:

Bad file and discard files are empy

Log file automatically created by oracle just we have to give the path with
valid name.
login sql:
conn: system/sysdba
syntax: create directory <<directoryname>> as <<>>directory path
sql>>create directory cust_name as
'C:\Users\Nagendra\Desktop\customer'
sql>>grant read, write on directory cust_name to scott;
conn: scott/tiger
create table: ( table should be empty)

open command prompt:


C:\>sqlldr userid=scott/tiger
control=C:\Users\Nagendra\Desktop\customer\customer_ctl.ctl
data=C:\Users\Nagendra\Desktop\customer\customer_det1.dat
bad=C:\Users\Nagendra\Desktop\customer\cutomer_bad.bad
discard=C:\Users\Nagendra\Desktop\customer\cutomer_dis.dis
log=C:\Users\Nagendra\Desktop\customer\cutomerlog.log;

You might also like