sqlloader
SQL LOADER SQL LOADER utility is used to load data from other data source into Oracle. For example, if you have a table in FOXPRO, ACCESS or SYBASE or any other third party database, you can use SQL Loader to load the data into Oracle Tables. SQL Loader will only read the data from Flat files. So If you want to load the data from Foxpro or any other database, you have to first convert that data into Delimited Format flat file or Fixed length format flat file, and then use SQL loader to load the data 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 fi