SQL*Loader能干什么

郑全

SQL*Loader能干什么:

• Load data across a network if your data files are on a different system than the database.
• Load data from multiple data files during the same load session.
• Load data into multiple tables during the same load session.
• Specify the character set of the data.
• Selectively load data (you can load records based on the records' values).
• Manipulate the data before loading it, using SQL functions.
• Generate unique sequential key values in specified columns.
• Use the operating system's file system to access the data files.
• Load data from disk, tape, or named pipe.
• Generate sophisticated error reports, which greatly aid troubleshooting.
• Load arbitrarily complex object-relational data.
• Use secondary data files for loading LOBs and collections.
• Use conventional, direct path, or external table loads.

参见oracle 联机文档：https://docs.oracle.com/en/datab ... abase-utilities.pdf