装载器(SQL*Loader)

使用SQL*Loader,可以以文件形式将数据装载到Oracle数据库表中.

1. 在Dos窗口里的SQL*Loader
在大多数平台上，SQL*Loader的执行程序名字为sqlldr.在文档中，它可能叫做sqlload.
在cmd中输入sqlldr将出现以下信息:
SQL*Loader: Release 8.1.5.0.0 - Production on Tue Jun 1 10:00:30 2004
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Usage: SQLLOAD 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( D e f ault 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: Conventional path 64, Direct path all)
bindsize -- Size of conventional path bind array in bytes (Default 65536)
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
s p e c i f i c a t i o n s
parallel -- do parallel load (Default FALSE)
file -- File to allocate extents from
skip_unusable_indexes -- disallow/allow unusable indexes or index partitions
(Default FLASE)
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 65535)
PLEASE NOTE: Command -line parameters may be specified either by position or
by keywords . An example of the former cas‘es qildl oad scott/tiger fo'o; an
example of the latter is's qlload control = foo userid = scott/ti'g.e rOne may
specify paramters by position before but not after parameters specified by
keywords. For example , 'sqlload scott/tiger control =foo logfile =log' is
allowed , but 'sqlload scott/tigecro ntrol=foo log' isn ot, even though the
position of the parameter 'log' is correct.