Category Archives: SQL*Loader

Character Set in SQL*Loader

Sometimes we face a problem of SQL*Loader loading data into a wrong column OR only partial data gets loaded into a column. These issues might occur because of the characters in the data being loaded. By default SQL*Loader recognizes data of UTF-8 character set only. If unrecognized characters are found, SQL*Loader might treat it as… Read More »

SQL*Loader Concepts

SQL*Loader is a bulk loader utility used for moving data from external files into the Oracle database. Capabilities of SQL*Loader Can load data from multiple data files during the same load session Can load data into multiple tables during the same load session Can selectively load data (Records can be loaded based on the records’… Read More »