Oracle SQL loader的使用.docVIP

学习Oracle SQL loader 的使用 一：sql loader 的特点 oracle自己exp和imp可以oracle公司自己sql loader 工具却没有这方面的问题，它可以把一些以文本格式存放的数据顺利的导入到oracle数据blob等sql loader 的C:\sqlldr 　　SQL*Loader: Release 9.2.0.1.0 - Production on 星期六 10月 9 14:48:12 2004 Copyright (c) 1982, 2002, Oracle Corporation.? All rights reserved. 　　用法: SQLLDR keyword=value [,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(默256000)　　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)　　readsize -- Size of Read buffer??????????????? (默1048576)　　external_table -- use external table for load; NOT_USED, GENERATE_ONLY, EXECUTE(默NOT_USED)　　columnarrayrows -- Number of rows for direct path column array(默5000)　　streamsize -- Size of direct path stream buffer in bytes(默256000)　　multithreading -- use multithreading in direct path　　resumable -- enable or disable resumable for current session(默FALSE)　　resumable_name -- text string to help identify resumable statement　　resumable_timeout -- wait time (in seconds) for RESUMABLE(默7200)　　date_cache -- size (in entries) of