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 ...
Get Oracle9i™ Development by Example now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.