Oracle QL Loader的详细语法.docVIP

Oracle SQL Loader的详细语法 Oracle?? SQL?? Loader的详细语法???? SQL*LOADER是ORACLE的数据加载工具，通常用来将操作系统文件迁移到ORACLE数据库中。SQL*LOADER是大型数据?????仓库选择使用的加载方法，因为它提供了最快速的途径（DIRECT，PARALLEL）。现在，我们抛开其理论不谈，用实例来使您快速掌握SQL*LOADER的使用方法。???? ?首先，我们认识一下SQL*LOADER。???? ?在NT下，SQL*LOADER的命令为SQLLDR，在UNIX下一般为sqlldr/sqlload。???? ?如执行：d:\oraclesqlldr???? SQL*Loader:?? Release?? .0?? -?? Production?? on???星期二?? 1月?? 8?? 11:06:42?? 2002???? (c)?? Copyright?? 1999?? Oracle?? Corporation.?? All?? rights?? reserved.?????用法:?? SQLLOAD???关键字?? =???值?? [,keyword=value,...]?????有效的关键字:???? 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?? (全部默认)???? skip?? --?? Number?? of?? logical?? records?? to?? skip?? (默认0)???? load?? --?? Number?? of?? logical?? records?? to?? load?? (全部默认)???? errors?? --?? Number?? of?? errors?? to?? allow?? (默认50)???? rows?? --?? Number?? of?? rows?? in?? conventional?? path?? bind?? array?? or?? between?? direct?? path?? data?? saves?????（默认:???常规路径?? 64,???所有直接路径）???? bindsize?? --?? Size?? of?? conventional?? path?? bind?? array?? in?? bytes(默认65536)???? silent?? --?? Suppress?? messages?? during?? run?? (header,feedback,errors,discards,partitions)???? direct?? --?? use?? direct?? path?? (默认FALSE)???? parfile?? --?? parameter?? file:?? name?? of?? file?? that?? contains?? parameter?? specifications???? parallel?? --?? do?? parallel?? load?? (默认FALSE)???? file?? --?? File?? to?? allocate?? extents?? from???? skip_unusable_indexes?? --?? disallow/allow?? unusable?? indexes?? or?? index?? partitions(默认FALSE)???? skip_index_maintenance?? --?? do?? not?? maintain?? indexes,?? mark?? affected?? indexes?? as?? unusable(默认FALSE)???? commit_discontinued?? --?? commit?? loaded?? rows?? when?? load?? is?? discontinued(默认FALSE)???? reads