概述
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正确)
--这里只是列出一部分,具体查看文档
最后
以上就是醉熏寒风为你收集整理的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 w所遇到的程序开发问题。
如果觉得靠谱客网站的内容还不错,欢迎将靠谱客网站推荐给程序员好友。
发表评论 取消回复