100.In which situations does the Oracle Data Pump use external tables and not the direct path load w
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 column 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 答案:BCE 参考:https://docs.oracle.com/cd/B19306_01/server.102/b14215/dp_overview.htm#i1010293 The default method that Data Pump uses for loading and unloading data is direct path,when the structure of a table allows it. Note that if the table has any columns of datatype LONG,then direct path must be used.(排除D) Situations in Which Direct Path Load Is Not Used A table is in a cluster(排除A) There is an active trigger on a pre-existing table. (B正确) The table has encrypted columns(C正确) A referential integrity constraint is present on a pre-existing table.(E正确) --这里只是列出一部分,具体查看文档 原文链接:https://www.f2er.com/oracle/213308.html