ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 043-097

043-097

原创 Linux操作系统 作者:jbymy2000 时间:2012-03-07 21:26:45 0 删除 编辑
97. Users in your production database complain that they are getting
the following error message while trying to insert rows into the ORDE
RS table:
ERROR at line 1:
ORA-01654: unable to extend index USERS.ORDERS_IND by 8 in tablespace
INDEXES
While investigating, you find that the INDEXES tablespace has run out
of space and there is no more free space on the disk where the data
files are available. Which two actions could you perform. to overcome
this error without affecting the queries that are currently being exe
cuted? (Choose two)
A. Drop and re-create the inbox.
B. Coalesce the ORDERS_IND index.
C. Coalesce the INDEXES tablespace.
D. Drop and re-create the ORDERS table.
E. Rebuild the index online and move it to another tablespace.
Answer: B, E
Coalesce the ORDERS_IND index.----------合并索引碎片
是针对具体索引,不是其所在表空间

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

上一篇: 043-096
下一篇: 043-098
请登录后发表评论 登录
全部评论

注册时间:2012-01-10

  • 博文量
    416
  • 访问量
    205800