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博客 ” ，链接：https://blog.itpub.net/11312660/viewspace-718000/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
