Oracle OCP IZ0-053 Q432(Segment Shrink)
432.For which of the following can you use Segment Shrink? (Choose all that apply.)
A. Heap tables
B. Tables with function-based indexes
C. Indexes
D. Partitions and subpartitions
E. None of the above
Answer: ACD
带有函数索引的表不能收缩段
参考：https://docs.oracle.com/cd/B28359_01/server.111/b28310/schema003.htm
A. Heap tables
B. Tables with function-based indexes
C. Indexes
D. Partitions and subpartitions
E. None of the above
Answer: ACD
带有函数索引的表不能收缩段
参考：https://docs.oracle.com/cd/B28359_01/server.111/b28310/schema003.htm
Shrink operations can be performed only on segments in locally managed tablespaces with automatic segment space management (ASSM). Within an ASSM tablespace, all segment types are eligible for online segment shrink except these:
-
IOT mapping tables
-
Tables with rowid based materialized views
-
Tables with function-based indexes
-
SECUREFILE LOBs
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/8520577/viewspace-2061264/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
