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.
列类型中有时区类型时,导入数据文件的时区与导入或导出系统有差异
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 pathload whileexporting a table? (Choose all that apply.)A.if a table is not in a clusterB.if a table has