What Is SQL*Loader
Oracle Databases today are ever increasing in complexity and size. Gigabyte-sized databases are common, and data warehouses are often reaching the terabyte-sized range. With the growth of these databases, the need to populate them with external data quickly and efficiently is of paramount importance. To handle this challenge, Oracle provides a tool called SQL*Loader that loads data from external data files into an Oracle database.
SQL*Loader has many functions that include the following capabilities:
Data can be loaded from multiple input data files of differing file types.
Input records can be of fixed and variable lengths.
Multiple tables can be loaded in the same run. SQL*Loader can also logically load selected records into ...