Oracle impdp参数说明和导入数据库的SQL语句写法

- 日理万妓 2022-06-10 09:12 203阅读 0赞

一、impdp导入数据库的SQL写法

1、按用户导入schemas=SYSTEM,数据库名EFMIS

impdp system/orcl@orcl  **(@orcl 可以不加)  **dumpfile=EFMIS.DMP  directory=tian  schemas=SYSTEM;

2、并行进程PARALLEL

impdp system/orcl@orcl  **(@orcl 可以不加)  **dumpfile=EFMIS.DMP  directory=tian  parallel=40 job\_name=SYSTEM;

3、按表名导入

impdp system/orcl@orcl  **(@orcl 可以不加)  **  tables=name,age dumpfile=EFMIS.DMP  directory=tian;

4、按查询条件导入

impdp system/orcl@orcl  **(@orcl 可以不加)  **tables=name,age dumpfile=EFMIS.DMP  directory=tian;

5、导入整个数据库

impdp system/orcl@orcl  **(@orcl 可以不加)** directory=tian dumpfile=EFMIS.DMP full=y;

6、按表空间导入

impdp system/orcl@orcl  **(@orcl 可以不加)  **tablespaces=name,age dumpfile=EFMIS.DMP  directory=tian;

以上如果想要连log日志一起导入，直接在dumpfile=EFMIS.DMP后加上logfile=EFMIS.LOG即可

如果数据表中表已经存在，会提示错误，在后面加上ignore=y就可以了

例如：impdp system/orcl@orcl  **(@orcl 可以不加)  **dumpfile=EFMIS.DMP  logfile=EFMIS.LOGdirectory=tian full=y;

**程序报错：****expdp ORA-14460: only one COMPRESS or NOCOMPRESS clause may be specified**

**如果程序导入报错可以加入：TRANSFORM=segment\_attributes:n**

**impdp参数表：**

<table style="margin:0px; padding:0px; line-height:25px; word-wrap:break-word; empty-cells:show; border-collapse:collapse; color:rgb(0,0,0); font-family:Tahoma,&quot;Microsoft Yahei&quot;,simsun"> 
 <tbody style="word-wrap:break-word"> 
 <tr style="word-wrap:break-word"> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> 参数名称 </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> 默认值 </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> 设置格式 </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> 说明 </td> 
 </tr> 
 <tr style="word-wrap:break-word"> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> ATTACH </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> &nbsp; </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> ATTACH= [schema_name.]job_name </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> 设置客户会话与已存在的作业之间的关联 </td> 
 </tr> 
 <tr style="word-wrap:break-word"> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> CONTENT </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> ALL </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> CONTENT= {ALL|DATA_ONLY|METADATA_ONLY} </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> 设置要导出的内容，设置为ALL时，会导入对象定义及其数据；设置为DATA_ONLY时，只导入数据；设置为METADATA_ONLY时，只导入对象定义 </td> 
 </tr> 
 <tr style="word-wrap:break-word"> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> DIRECTORY </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> &nbsp; </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> DIRECTORY=’文件目录’ </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> 指定导入文件的目录 </td> 
 </tr> 
 <tr style="word-wrap:break-word"> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> DUMPFILE </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> expdat.dmp </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> DUMPFILE=’文件名称.dmp’ </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> 指定导出文件名称 </td> 
 </tr> 
 <tr style="word-wrap:break-word"> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> ESTIMATE </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> BLOCKS </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> BLOCKS|STATISTICS </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> 设置计算磁盘空间的方法 </td> 
 </tr> 
 <tr style="word-wrap:break-word"> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> ESTIMATE_ONLY </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> N </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> ESTIMATE_ONLY={Y|N} </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> 只估算导出操作所需要的表空间，而不执行导出 </td> 
 </tr> 
 <tr style="word-wrap:break-word"> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> EXCLUDE </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> &nbsp; </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> EXCLUDE=对象类型.对象名称 </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> 设置不导入的对象 </td> 
 </tr> 
 <tr style="word-wrap:break-word"> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> FLASHBACK_SCN </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> &nbsp; </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> FLASHBACK_SCN=SCN号 </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> 只导入SCN时刻的表数据 </td> 
 </tr> 
 <tr style="word-wrap:break-word"> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> FLASHBACK_TIME </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> &nbsp; </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> FLASHBACK_TIME= ”TO_TIMESTAMP(time-value)” </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> 只导入指定时间的表数据 </td> 
 </tr> 
 <tr style="word-wrap:break-word"> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> FULL </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> N </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> FULL=Y </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> 是否导入整个导出文件的全部数据库 </td> 
 </tr> 
 <tr style="word-wrap:break-word"> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> HELP </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> N </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> HELP=Y </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> 是否显示IMPDP命令参数的帮助信息 </td> 
 </tr> 
 <tr style="word-wrap:break-word"> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> INCLUDE </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> &nbsp; </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> INCLUDE= Object_type[:name_clause][,…] </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> 设置要导入的对象，这个选项不能和EXCLUDE同时使用 </td> 
 </tr> 
 <tr style="word-wrap:break-word"> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> JOB_NAME </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> SYS_EXPORT_ &lt;mode&gt;_NN </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> JOB_NAME=作业名称 </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> 设置导入作业的名称 </td> 
 </tr> 
 <tr style="word-wrap:break-word"> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> LOG_FILE </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> export.log </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> LOGFILE= [directory_object:]file_name </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> 设置导入日志文件的名称 </td> 
 </tr> 
 <tr style="word-wrap:break-word"> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> NETWORK_LINK </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> &nbsp; </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> NETWORK_LINK= source_database_link </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> 设置执行导入操作的数据库链名 </td> 
 </tr> 
 <tr style="word-wrap:break-word"> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> NOLOGFILE </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> N </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> NOLOGFILE={Y|N} </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> 禁止生成导入日志文件 </td> 
 </tr> 
 <tr style="word-wrap:break-word"> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> PARALLEL </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> 1 </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> PARALLEL=参数 </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> 设置并行导入的并行进程个数 </td> 
 </tr> 
 <tr style="word-wrap:break-word"> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> PARFILE </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> &nbsp; </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> PARFILE= [directory_path]file_name </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> 使用参数文件设置参数 </td> 
 </tr> 
 <tr style="word-wrap:break-word"> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> QUERY </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> &nbsp; </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> QUERY= [schema.][table_name:]query_clause </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> 在这个选项中指定WHERE条件诗句，使IMPDP只导入这个查询结果的数据 </td> 
 </tr> 
 <tr style="word-wrap:break-word"> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> REMAP_DATAFILE </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> &nbsp; </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> REMAP_DATAFILE= source_datafile:target_datafile </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> 将源数据文件转变为目标数据文件名，在不同平台之间移动表空间时使用这个参数 </td> 
 </tr> 
 <tr style="word-wrap:break-word"> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> REMAP_SCHEMA </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> &nbsp; </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> REMAP_SCHEMA= source_schema:target_schema </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> 将源方案的所有对象导入到目标方案中 </td> 
 </tr> 
 <tr style="word-wrap:break-word"> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> REMAP_TABLESPACE </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> &nbsp; </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> REMAP_TABLESPACE= Source_tablespace:target_tablespace </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> 将源表空间的所有对象移到目标表空间中 </td> 
 </tr> 
 <tr style="word-wrap:break-word"> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> REUSE_DATAFILES </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> N </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> REUSE_DATAFILES={Y|N} </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> 是否覆盖已存在的数据文件，设置为N时不覆盖 </td> 
 </tr> 
 <tr style="word-wrap:break-word"> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> SCHEMAS </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> 当前登录用户 </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> SCHEMAS=方案名称[,…] </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> 方案导入时要导入的方案 </td> 
 </tr> 
 <tr style="word-wrap:break-word"> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> SKIP_UNUSABLE_INDEXES </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> N </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> SKIP_UNUSABLE_INDEXES={Y|N} </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> 是否导入不能使用的索引 </td> 
 </tr> 
 <tr style="word-wrap:break-word"> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> TABLES </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> &nbsp; </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> TABLES= [schema_name.]table_name [:partition_name][,…] </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> 表导出时要导出的表名称 </td> 
 </tr> 
 <tr style="word-wrap:break-word"> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> SQLFILE </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> &nbsp; </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> SQLFILE= [directory_object:]file_name </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> 将导入过程中需要执行的DDL诗句写到指定的SQL脚本文件中 </td> 
 </tr> 
 <tr style="word-wrap:break-word"> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> STATUS </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> 0 </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> STATUS=[整数] </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> 显示导入作业进程的详细状态 </td> 
 </tr> 
 <tr style="word-wrap:break-word"> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> STREAMS_CONFIGURATION </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> Y </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> STREAMS_CONFIGURATION={Y|N} </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> 设置是否要导入流源数据(Stream Metadata) </td> 
 </tr> 
 <tr style="word-wrap:break-word"> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> TABLE_EXISTS_ACTION </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> SKIP </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> TABLE_EXISTS_ACTION= {SKIP|APPEND|TRUNCATE|REPLACE} </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> 设置当表已经存在时应该执行的操作，SKIP表示跳过这张已存在的表，处理下一个对象；APPEND表示为表追加数据；TRUNCATE表示截断表，并为其追加数据；REPLACE表示删除已存在的表，重新建立表并添加数据 </td> 
 </tr> 
 <tr style="word-wrap:break-word"> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> TABLES </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> &nbsp; </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> TABLES= [schema_name.]table_name [:partition_name] </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> 设置要导入的表名 </td> 
 </tr> 
 <tr style="word-wrap:break-word"> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> TABLESPACES </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> &nbsp; </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> TABLESPACES= Tablespace_name[,…] </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> 表空间导入时要导入的表空间名称 </td> 
 </tr> 
 <tr style="word-wrap:break-word"> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> TRANSFORM </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> &nbsp; </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> TRANSFORM= Transform_name:value[:object_type] </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> 设置是否修改建立对象的DDL语句 </td> 
 </tr> 
 <tr style="word-wrap:break-word"> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> TRANSPORT_DATAFILES </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> &nbsp; </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> TRANSPORT_DATAFILES= datafile_name </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> 指定移动表空间时要导入到目标数据库的数据文件名称 </td> 
 </tr> 
 <tr style="word-wrap:break-word"> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> TRANSPORT_TABLESPACES </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> &nbsp; </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> TRANSPORT_TABLESPACES= Tablespace_name[,…] </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> 进行表空间模式导入 </td> 
 </tr> 
 <tr style="word-wrap:break-word"> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> TRANSPORT_FULL_CHECK </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> N </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> TRANSPORT_FULL_CHECK={Y|N} </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> 检查表空间之间的关联关系，这个值设置为y时，只要已移动的表空间和未移动的表空间存在关联关系，就提示出错；设置为N时，只检查单方依赖，例如如果索引表空间移动了，而基表表空间未移动，会出现错误消息。但如果基表移动了，而索引表空间未移动，则不提示出错 </td> 
 </tr> 
 <tr style="word-wrap:break-word"> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> VERSION </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> COMPATIBLE </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> VERSION={COMPATIBLE |LATEST|version_string} </td> 
 <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; word-wrap:break-word"> 指定目标数据库的数据库版本 </td> 
 </tr> 
 </tbody> 
</table>