which of the following can you use Segment Shrink?

For which of the following can you use Segment Shrink? (Choose all that apply.)

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

Show Hint

Leave a Reply 1

Your email address will not be published. Required fields are marked *

Helcio

Helcio

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

Reply