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

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部落格 ” ，連結：http://blog.itpub.net/8520577/viewspace-2061264/，如需轉載，請註明出處，否則將追究法律責任。