samar
SQLLoader
1 Answer(s)      4 years and 9 months ago
Posted in : SQL

hello,,

What is SQLLoader?

Advertisement
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, 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
What is SQLLoader?
What is SQLLoader?  What is SQLLoader
Advertisements