1 Replies - 585 Views - Last Post: 20 June 2012 - 06:58 AM Rate Topic: -----

#1 busyme12srv  Icon User is offline

  • New D.I.C Head

Reputation: -5
  • View blog
  • Posts: 44
  • Joined: 18-June 12

Importing MSAccess Data into Oracle database file using SQLLDR

Posted 20 June 2012 - 03:59 AM

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.


Is This A Good Question/Topic? 0
  • +

Replies To: Importing MSAccess Data into Oracle database file using SQLLDR

#2 modi123_1  Icon User is online

  • Suitor #2
  • member icon



Reputation: 9195
  • View blog
  • Posts: 34,527
  • Joined: 12-June 08

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.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1