[busyme12srv]

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

database.

Steps:

1. Create a text-file (.txt) file eg. datafile.dat from MSAccess database

file.

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

command:
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

CONTROL=datafile.CTL LOG=datafile.LOG

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.

[modi123_1]

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.