Difference between the SQL*Loader and IMPORT utilities.

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.
What is Bitmapped indexes? What is b-tree index in oracle?
In a Bitmap index, a 2 dimensional array is created. The array represents the index value multiplied by number of rows...
Difference between REF Cursor & Normal Cursor in oracle
Normal cursors fall under the category of static cursors while REF cursors are dynamic.....
What is Global temporary table in oracle? and what are the benefits of it?
GLOBAL TEMPORARY TABLE is used to store temporary data in scenarios where complex calculation is involved....
Post your comment