View the Exhibit and examine the properties of the USERS tablespace.
You execute the following statement to shrink the TRANS table existing on the USERS tablespace:
SQL> ALTER TABLE trans SHRINK SPACE CASCADE;
Which objects would be affected by this command? (Choose all that apply.)
Exhibit:
A.
the materialized views based on the TRANS table
B.
the materialized views log of the TRANS table
C.
the TRANS table
D.
the B*Tree indexes on the TRANS table
E.
the large object (LOB) segments of the TRANS table
The option “E” is incorrect only on Oracle 10G R1 but is correct for the Oracle 10G R2.
The valid answers for Oracle 10G R2 would be “C,D,E”
According to Oracle documentation:
– From Oracle® Database SQL Reference 10g Release 1 (10.1)
ALTER TABLE
Restrictions on the shrink_clause
Segment shrink is not supported for LOB segments even if CASCADE is specified.
========================================
2. Segment shrink is not supported for LOB segments even if CASCADE is specified.
– From Oracle® Database SQL Reference 10g Release 2 (10.2)
ALTER TABLE
Restrictions on the shrink_clause
There is not restrictions about for lob segments. Indeed the documentation say that in Oracle 10G R2 now the CASCADE option shrink log segments.
– Other Oracle Documentation notes
SEGMENT SHRINK and Details. [ID 242090.1]