我是靠谱客的博主 醉熏寒风,最近开发中收集的这篇文章主要介绍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正确)
--这里只是列出一部分,具体查看文档

最后

以上就是醉熏寒风为你收集整理的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所遇到的程序开发问题。

如果觉得靠谱客网站的内容还不错,欢迎将靠谱客网站推荐给程序员好友。

本图文内容来源于网友提供,作为学习参考使用,或来自网络收集整理,版权属于原作者所有。
点赞(41)

评论列表共有 0 条评论

立即
投稿
返回
顶部