基于SQL*Loader的海量数据装载方案优化

Optimization of Massive Data Loading Program Based on SQL*Loader

SQL*Loader是Oracle数据库提供的一种将外部数据文件中的数据装载到数据库表中的数据装载工具。介绍了SQL*Loader的工作机制、组件和装载方式,并通过对常用数据装载方案的分析,提出了一种数据装载改进方案。最后通过实际测试证明了该改进方案的优势。

SQL＊Loader is a data loading tool that loads data from external files into tables of an Oracle database.This paper briefly introduced the working mechanism of SQL ＊ Loader,components and loading methods.Through analysis of the common data loading program,an improved data loading method was then proposed.Finally,the advantage of improvement program was proved by actual test.