1Z0-053 V13.02 Q433

433.When shrinking a table segment, you choose to shrink all the indexes for that table using the SHRINK SPACE command. Which clause should you use?
A. INCLUDING DEPENDENCIES
B. INCLUDING DEPENDENCIES CASCADE
C. COMPACT
D. CASCADE
E. None of the above
Answer: D

当收缩一个表段，你选择使用收缩空间命令收缩该表的所有索引。你应该使用哪一条子句？

使用SHRINK SPACE子句可以收缩段中的空间。如果指定了CASCADE，则收缩行为将 级联到所有支持收缩操作的从属段，但实体化视图、LOB 索引和IOT（索引表）映射表 例外。

SQL> alter table emp shrink space cascade;

表已更改。

SQL> alter table emp shrink space compact;

表已更改。

SQL> alter table emp shrink space including dependencies;
alter table emp shrink space including dependencies
                             *
第 1 行出现错误:
ORA-10630: Illegal syntax specified with SHRINK clause

SQL> alter table emp shrink space including dependencies cascade;
alter table emp shrink space including dependencies cascade
                             *
第 1 行出现错误:
ORA-10630: Illegal syntax specified with SHRINK clause

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/81227/viewspace-2124093/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/81227/viewspace-2124093/