October 28, 2010 at 4:59 PM
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.
- Convert the Data into Flat file using third party database command.
- Create the Table Structure in Oracle Database using appropriate datatypes
- Write a Control File, describing how to interpret the flat file and options to load the data.
- Execute SQL Loader utility specifying the control file in the command line argument