OCP052_100_Situations in Which Direct Path Load Is Not Used(译)

100. In which situations does the Oracle Data Pump use external tables and not the direct path
load while
exporting a table? (Choose all that apply.)
A.if a table is not in a cluster
B.if a table has an active trigger
C.if a table has an encrypted
D.if a table has a column of data type LONG defined on it
E.if a table has a referential integrity constraint defined on it
Answer: BCE

Situations in Which Direct Path Load Is Not Used
不能使用直接路径加载的情况
If any of the following conditions exist for a table, then 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.
   存在为LOB类型的列的索引
 A table is in a cluster.
   簇表
 There is an active trigger on a preexisting table.
   导入的表已存在,且有效且作用对象为的触发器
 Fine-grained access control is enabled in insert mode on a preexisting table.
   导入的表已存在,且插入模式有生效的细粒度访问控制
 A table contains BFILE columns or columns of opaque types.
   表存在二进制文件或模糊类型(XMLType)列
	Oracle OPAQUE types are abstract data types. With data implemented as simply a series of bytes, the internal representation is not exposed.  
 A referential integrity constraint is present on a preexisting table.
   导入的表已存在,且存在完整性约束  1、 not null 2、 unique key 3、 primary key 4、 foreign key 5、 check constraints 6、 REF
 A table contains VARRAY columns with an embedded opaque type.
   表存在列类型为包含模糊类型的数组
 The table has encrypted columns.
   表存在加密列
 The table into which data is being imported is a preexisting table and at least one of the following conditions exists:
	o There is an active trigger
	o The table is partitioned
	o Fine-grained access control is in insert mode
	o A referential integrity constraint exists
	o 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.
	数据泵命令对指定的表用参数 :QUERY , SAMPLE ,or REMAP_DATA
 A table contains a column (including a VARRAY column) with a TIMESTAMP WITH TIME ZONE datatype 
    and the version of the time zone data file is different between the export and import systems.
   列类型中有时区类型时,导入数据文件的时区与导入或导出系统有差异