SQL*Loader (sqlldr) is the utility to use for high performance data
loads. The data can be loaded from any text file and inserted into the
1. Create a text-file (.txt) file eg. datafile.dat from MSAccess database
2. Replace the field delimiters by ','(comma)
3. Start 'Run SQL Command Line' option in Oracle Database software.
4. At the Sql> command prompt in Oracle, using CREATE TABLE
command to create an oracle table with the respective fields.
5. At the Oracle prompt create file datafile.CTL using the following
LOAD DATA INFILE datafile.dat INTO TABLE NEWDATA replace fields
terminated by ',' ( Sno,Name,Address,Designation)
6. At the prompt again apply the SQLLDR command to create the
database file in oracle.
7.SQLLDR username/password DATA=datafile.dat
After you have executed the above command SQL Loader will show you
the output describing how many rows it has loaded.
The LOG option of sqlldr specifies where the log file of this sql loader
session should be created.
The log file contains all actions which SQL loader has performed i.e.
how many rows were loaded, how many were rejected and how much
time is taken to load the rows and etc. You have to view this file for any
errors encountered while running SQL Loader.
1 Replies - 536 Views - Last Post: 20 June 2012 - 06:58 AM
Replies To: Importing MSAccess Data into Oracle database file using SQLLDR
Re: Importing MSAccess Data into Oracle database file using SQLLDR
Posted 20 June 2012 - 06:58 AM
If you feel you want to flesh this out and submit it as a tutorial that would be great, but right now I am not sure exactly what this post (or the last) were for.
Page 1 of 1