重庆思庄Oracle、Redhat认证学习论坛

标题: SQL*Loader能干什么 [打印本页]

作者: 郑全    时间: 2019-11-8 17:29
标题: 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







欢迎光临 重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/) Powered by Discuz! X3.2