数据泵导入SKIP_CONSTRAINT_ERRORS的bug（三）

核心提示： ■ The table has encrypted columns■ The table into which data is being imported is a pre-existing table and at least one of the following conditio

■ The table has encrypted columns

■ The table into which data is being imported is a pre-existing table and at least one of the following conditions exists:

– There is an active trigger

– The table is partitioned

– Fine-grained access control is in insert mode

– A referential integrity constraint exists

– A unique index exists

■ Supplemental logging is enabled and the table has at least one LOB column.

■ The Data Pump command for the specified table used the QUERY， SAMPLE， or REMAP_DATA parameter.

文档描述的十分清晰，对于表已经存在的情况，当表包含活动触发器、表为分区表、细粒度存储控制插入模式、参考完整性约束以及唯一索引存在等五个条件，会导入加载使用外部表方式。

那么现在其实已经很明确了，这个参数对于直接路径导入无效，而只在外部表导入时生效。

最后再验证一下：

SQL> ALTER TABLE T_CONS DROP CONSTRAINT FK_T_CONS_ID;

表已更改。

SQL> TRUNCATE TABLE T_CONS;

表被截断。

SQL> ALTER TABLE T_CONS ADD PRIMARY KEY (ID);

表已更改。

SQL> INSERT INTO T_CONS SELECT ROWNUM， TNAME FROM TAB WHERE ROWNUM < 10;

已创建9行。

SQL> COMMIT;

提交完成。

SQL>HOSTimpdpyangtk/yangtkdirectory=d_outputdumpfile=t_cons.dpcontent=data_onlydata_options=skip_constraint_errors
Import:Release11.1.0.6.0-64bitProductionon星期四，1610月，20081:54:03
Copyright(c)2003，2007，Oracle.Allrightsreserved.
连接到:OracleDatabase11gEnterpriseEditionRelease11.1.0.6.0-64bitProduction
WiththePartitioning，OLAP，DataMiningandRealApplicationTestingoptions已成功加载/卸载了主表"YANGTK"."SYS_IMPORT_FULL_01"启动"YANGTK"."SYS_IMPORT_FULL_01":yangtk/********directory=d_outputdumpfile=t_cons.dpcontent=data_onlydata_options=skip_constraint_errors处理对象类型TABLE_EXPORT/TABLE/TABLE_DATA