数据泵导入SKIP_CONSTRAINT_ERRORS的bug(三)
2008-10-25 12:57:57 来源:WEB开发网ORA-02291: 违反完整约束条件 (YANGTK.FK_T_CONS_ID) - 未找到父项关键字。
作业 "YANGTK"."SYS_IMPORT_FULL_01" 已于 01:24:51 成功完成。
上面建立了一张主表,并建立了主键,然后去掉了T_CONS上面的唯一索引和CHECK约束,建立外键,并建立了一个普通的索引。
根据上一篇文章的测试,如果确实主键,SKIP_CONSTRANT_ERRORS将不起作用,可是这里确发现,SKIP_CONSTRAINT_ERRORS参数生效了。
看来唯一索引只是一个SKIP_CONSTRAINT_ERRORS生效的一个因素而已,而外键似乎也可以使这个参数生效。
而这两个条件,恰好是不使用直接路径加载,采用外部表方式导入的条件。Oracle的文档是这样描述的:
Situations in Which Direct Path Load Is Not Used
If any of the following conditions exist for a table, Data Pump uses external tables rather than direct path to load the data for that table:
■ A global index on multipartition tables exists during a single-partition load. This includes object tables that are partitioned.
■ A domain index exists for a LOB column.
■ A table is in a cluster.
■ There is an active trigger on a pre-existing table.
■ Fine-grained access control is enabled in insert mode on a pre-existing table.
■ A table contains BFILE columns or columns of opaque types.
■ A referential integrity constraint is present on a pre-existing table.
■ A table contains VARRAY columns with an embedded opaque type.
更多精彩
赞助商链接