What is the difference between the SQL*Loader and IMPORT utilities?SQL*Loader is a high speed data loading mechanism. It can load data from external files into tables of the database. IMPORT does not support any direct options while SQL*Loader does. Import has more tuning limitations. IMPORT is mainly used for reading and writing the operating system files.What is the difference between the SQL*Loader and IMPORT utilities?SQL*Loader can be used to load data from Delimiter separated files and fixed or variable width text. On the other hand, the import utility read files that are generated by other export utility of oracle.
|