The two statements that are true about shrinking a segment online are:
E. To shrink a table it must have row movement enabled
F. It must be in a tablespace that uses Automatic Segment Space Management (ASSM)
The other statements are false:
A. It is not possible to shrink either indexes or Index Organized Tables (IOTs) - It is possible to shrink indexes and IOTs, but it is more complex than shrinking a table.
B. It always eliminates all migrated rows if any exist in the table - Shrinking a segment does not always eliminate all migrated rows. Only migrated rows that are no longer referenced by any other rows will be eliminated.
C. To shrink a table it must have a PRIMARY KEY constraint - It is not necessary for a table to have a PRIMARY KEY constraint to be shrunk.
D. To shrink a table it must have a UNIQUE KEY constraint - It is not necessary for a table to have a UNIQUE KEY constraint to be shrunk.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
you1234
Highly Voted 3 years, 6 months agoEkos
3 years, 1 month agoama
3 years, 6 months agoleozanon94
2 years, 7 months agoLalala8
Most Recent 3 months, 2 weeks agoOracle2020
4 months, 4 weeks agoauwia
6 months, 2 weeks agoKuraudio
1 year, 1 month ago