SQL Loader – Control File Sample To Load Fixed Length Data File
Control File Data File
Category: SQLLoader
Control File Data File
Control File to read CSV File Data File Place the files in the below location (You have to consider the directories according to your directory structure and make sure to change the data file location in control file)
Points to consider about data file Data File File Format (CSV/DATA/….etc) Fixed Length /Variable Length DataTypes of each column, width Frequency (per hour, per week, per month etc..) Location of the file Database Table The data file can be in fixed record format or variable record format.Fixed Record Format would look like the below. In […]
SQL LOADER is an Oracle utility used to load data into table given a datafile which has the records that need to be loaded. SQL*Loader takes data file, as well as a control file, to insert data into the table. When a Control file is executed, it can create Three (3) files called log file, […]