SQLLoader

SQLLoader

hello,,

What is SQLLoader?

View Answers

October 28, 2010 at 4:59 PM

hii,

SQL LOADER utility is used to load data from other data source into Oracle.

Following is procedure to load the data from Third Party Database into Oracle using SQL Loader.

  1. Convert the Data into Flat file using third party database command.
  2. Create the Table Structure in Oracle Database using appropriate datatypes
  3. Write a Control File, describing how to interpret the flat file and options to load the data.
  4. Execute SQL Loader utility specifying the control file in the command line argument









Related Tutorials/Questions & Answers:
SQLLoader
SQLLoader  hello,, What is SQLLoader?   hii,ADS_TO_REPLACE_1 SQL LOADER utility is used to load data from other data source into Oracle. Following is procedure to load the data from Third Party Database into Oracle
What is SQLLoader?
What is SQLLoader?  What is SQLLoader
Advertisements

Ads