100.In which situations does the Oracle Data Pump use extern
发布时间：2020-12-12 16:11:46 所属栏目：百科 来源：网络整理
导读：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 enc
|
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正确) --这里只是列出一部分，具体查看文档 （编辑：李大同） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |