EXPIMP参数参考手册.doc

EXP/IMP参数参考手册 帮助命令：exp help=yExport: Release 10.2.0.1.0 - Production on Thu Jul 20 10:39:50 2006 Copyright (c) 1982, 2005, Oracle. All rights reserved. You can let Export prompt you for parameters by entering the EXPcommand followed by your username/password: Example: EXP SCOTT/TIGER Or, you can control how Export runs by entering the EXP command followedby various arguments. To specify parameters, you use keywords: Format: EXP KEYWORD=value or KEYWORD=(value1,value2,.,valueN) Example: EXP SCOTT/TIGER GRANTS=Y TABLES=(EMP,DEPT,MGR) or TABLES=(T1:P1,T1:P2), if T1 is partitioned table USERID must be the first parameter on the command line. Keyword Description (Default) Keyword Description (Default)-USERID username/password FULL export entire file (N)BUFFER size of data buffer OWNER list of owner usernamesFILE output files (EXPDAT.DMP) TABLES list of table namesCOMPRESS import into one extent (Y) RECORDLENGTH length of IO recordGRANTS export grants (Y) INCTYPE incremental export typeINDEXES export indexes (Y) RECORD track incr. export (Y)DIRECT direct path (N) TRIGGERS export triggers (Y)LOG log file of screen output STATISTICS analyze objects (ESTIMATE)ROWS export data rows (Y) PARFILE parameter filenameCONSISTENT cross-table consistency(N) CONSTRAINTS export constraints (Y) OBJECT_CONSISTENT transaction set to read only during object export (N)FEEDBACK display progress every x rows (0)FILESIZE maximum size of each dump fileFLASHBACK_SCN SCN used to set session snapshot back toFLASHBACK_TIME time used to get the SCN closest to the specified timeQUERY select clause used to export a subset of a tableRESUMABLE suspend when a space related error is encountered(N)RESUMABLE_NAME text string used to identify resumable statementRESUMABLE_TIMEOUT wait time for RESUMABLE TTS_FULL_CHECK perform full or partial dependency check for TTSVOLSIZE number of bytes to write to each tape volumeTABLESPACES list of tablespaces to exportTRANSPORT_TABLESPACE export transportable tablespace metadata (N)TEMPLATE template name which invokes iAS mode export Export terminated successfully without warnings. -中文版：通过输入 EXP 命令和用户名/口令，您可以在用户 / 口令之后的命令:实例: EXP SCOTT/TIGER或者，您也可以通过输入跟有各种参数的 EXP 命令来控制“导出”的运行方式。要指定参数，您可以使用关键字:格式: EXP KEYWORD=value 或 KEYWORD=(value1,value2,.,valueN)实例: EXP SCOTT/TIGER GRANTS=Y TABLES=(EMP,DEPT,MGR)或 TABLES=(T1: P1,T1: P2)，如果 T1 是分区表USERID 必须是命令行中的第一个参数。关键字 说明（默认）-USERID 用户名/口令FULL 导出整个文件 (N)BUFFER 数据缓冲区的大小OWNER 所有者用户名列表FILE 输出文件 (EXPDAT.DMP)TABLES 表名列表COMPRESS 导入一个范围 (Y)RECORDLENGTH IO 记录的长度GRANTS 导出权限 (Y)INCTYPE 增量导出类型INDEXES 导出索引 (Y)RECORD 跟踪增量导出 (Y)ROWS 导出数据行 (Y)PARFILE 参数文件名CONSTRAINTS 导出限制 (Y)CONSISTENT 交叉表一致性LOG 屏幕输出的日志文件STATISTICS 分析对象 (ESTIMATE)DIRECT 直接路径 (N)TRIGGERS 导出触发器 (Y)FEEDBACK 显示每 x 行 (0) 的进度FILESIZE 各转储文件的最大尺寸QUERY 选定导出表子集的子句下列关键字仅用于可传输的表空间TRANSPORT_TABLESPACE 导出可传输的表空间元数据 (N)TABLESPACES 将传输的表空间列表帮助命令：imp help=yImport: Release 10.2.0.1.0 - Production on Thu Jul 20 10:43:46 2006 Copyright (c) 1982, 2005, Oracle. All rights reserved. You can let Import prompt you for parameters by entering the IMPcommand followed by your username/password: Example: IMP SCOTT/TIGER Or, you can control how Import runs by entering the IMP command followedby various arguments. To specify parameters, you use keywords: Format: IMP KEYWORD=value or KEYWORD=(value1,value2,.,valueN) Example: IMP SCOTT/TIGER IGNORE=Y TABLES=(EMP,DEPT) FULL=N or TABLES=(T1:P1,T1:P2), if T1 is partitioned table USERID must be the first parameter on the command line. Keyword Description (Default) Keyword Description (Default)-USERID username/password FULL import entire file (N)BUFFER size of data buffer FROMUSER list of owner usernamesFILE input files (EXPDAT.DMP) TOUSER list of usernamesSHOW just list file contents (N) TABLES list of table namesIGNORE ignore create errors (N) RECORDLENGTH length of IO recordGRANTS import grants (Y) INCTYPE incremental import typeINDEXES import indexes (Y) COMMIT commit array insert (N)ROWS import data rows (Y) PARFILE parameter filenameLOG log file of screen output CONSTRAINTS import constraints (Y)DESTROY overwrite tablespace data file (N)INDEXFILE write table/index info to specified fileSKIP_UNUSABLE_INDEXES skip maintenance of unusable indexes (N)FEEDBACK display progress every x rows(0)TOID_NOVALIDATE skip validation of specified type ids FILESIZE maximum size of each dump fileSTATISTICS import precomputed statistics (always)RESUMABLE suspend when a space related error is encountered(N)RESUMABLE_NAME text string used to identify resumable statementRESUMABLE_TIMEOUT wait time for RESUMABLE COMPILE compile procedures, packages, and functions (Y)STREAMS_CONFIGURATION import streams general metadata (Y)STREAMS_INSTANTIATION import streams instantiation metadata (N)VOLSIZE number of bytes in file on each volume of a file on tape The following keywords only apply to transportable tablespacesTRANSPORT_TABLESPACE import transportable tablespace metadata (N)TABLESPACES tablespaces to be transported into databaseDATAFILES datafiles to be transported into databaseTTS_OWNERS users that own data in the transportable tablespace set Import terminated successfully without warnings.-中文版可以通过输入 IMP 命令和您的用户名/口令跟有您的用户名 / 口令的命令:实例: IMP SCOTT/TIGER或者, 可以通过输入 IMP 命令和各种自变量来控制“导入”按照不同参数。要指定参数，您可以使用关键字:格式: IMP KEYWORD=value 或 KEYWORD=(value1,value2,.,vlaueN)实例: IMP SCOTT/TIGER IGNORE=Y TABLES=(EMP,DEPT) FULL=N或 TABLES=(T1: P1,T1: P2)，如果 T1 是分区表USERID 必须是命令行中的第一个参数。关键字 说明（默认） -USERID 用户名/口令FUL