ITPub博客

首页 > 数据库 > Oracle > Oracle OCP IZ0-053 Q432(Segment Shrink)

Oracle OCP IZ0-053 Q432(Segment Shrink)

原创 Oracle 作者:abstractcyj 时间:2016-03-21 17:08:25 0 删除 编辑
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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
曾从事java方向开发多年。近年已经转入数据库方向。主要擅长SQL优化,Oracle数据库问题诊断,Oracle备份与恢复等。服务于医药物流,医院等行业

注册时间:2010-01-26

  • 博文量
    555
  • 访问量
    834160