1.同时装载到分区表表的不同分区或同时装载到不同的表

2.分成多个服务器装载到分区表的单个分区或单个表，最后将装载的临时段合并保存到分区或表

3.两者对比(下面描述中传统导入方式称为前者，直接导入方式称为后者)

a.前者使用commit来保存数据，后者更新高水位线标记保存数据

b.前者产生redo记录，后者基于特定的条件产生redo记录

c.前者强制所有的约束，后者仅仅强制primarykey,unique,notnull约束

d.前者将触发insert触发器，后者不会触发insert触发器

e.前者支持簇表，后者不支持簇表

f.前者插入数据时其它用户可以DML表，后者则不行

五、演示SQL*Loader

1.SQL*Loader可执行程序(sqlldr)所在的位置

[oracle@vmoel5u4 ~]$ ls -lh $ORACLE_HOME/bin/sql*

-rwxr-x--x 1 oracle oinstall 634K Mar 24 2012 /u01/app/oracle/product/10.2.0/db_1/bin/sqlldr

2.查看sqlldr的帮助信息，

[oracle@oradb ~]$ sqlldr

SQL*Loader: Release 10.2.0.1.0- Production on Thu Sep 23 10:38:31 2010

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Usage: SQLLDR keyword=value [,keyword=value,...]

Valid Keywords:

userid -- ORACLE username/password

control -- control file name

log -- log file name

bad -- bad file name

data -- data file name

discard -- discard file name

discardmax -- number of discards to allow (Default all)

skip -- number of logical records to skip (Default 0)

load -- number of logical records to load (Default all)

errors -- number of errors to allow (Default 50)

rows -- number of rows in conventional path bind array or between direct path data saves

(Default: Conventionalpath 64, Direct path all)

bindsize -- size of conventional path bind array in bytes (Default 256000)

silent -- suppress messages during run (header,feedback,errors,discards,partitions)

direct -- use direct path (Default FALSE)

parfile -- parameter file: name of file that contains parameter specifications

parallel -- do parallel load (Default FALSE)

file -- file to allocate extents from

skip_unusable_indexes-- disallow/allow unusable indexes or index partitions (Default FALSE)

skip_index_maintenance-- do not maintain indexes, mark affected indexes as unusable (Default FALSE)

commit_discontinued -- commit loaded rows when load is discontinued (Default FALSE)

readsize -- size of read buffer (Default 1048576)

external_table -- use external table for load; NOT_USED, GENERATE_ONLY, EXECUTE (Default NOT_USED)

columnarrayrows -- number of rows for direct path column array (Default 5000)

streamsize -- size of direct path stream buffer in bytes (Default 256000)

multithreading -- use multithreading in direct path

resumable -- enable or disable resumable for current session (Default FALSE)

resumable_name -- text string to help identify resumable statement

resumable_timeout -- wait time (in seconds) for RESUMABLE (Default 7200)

date_cache -- size (in entries) of date conversion cache (Default 1000)

PLEASE NOTE: Command-line parameters may be specified eitherby

position or by keywords. An exampleof the former caseis 'sqlldr

scott/tiger foo'; an example of the latter is 'sqlldr control=foo

userid=scott/tiger'. One may specify parametersby position before