【oracle】oracledba8 NOLOGGING,oraclenologging
You noticed that the index tablespace in your database requires a
recovery. However, instead of performing a media recovery, you decide
d to re-create the indexes in a new tablespace. Which two options wou
ld you use to reduce the time it takes to re-create the indexes? (Choose two.)
A. ONLINE
B. REVERSE
C. PARALLEL
D. COMPRESS
E. NOLOGGING
F. COMPUTE STATISTICS
Answer: C, E
你注意到你的数据库中的索引表空间要求恢复。然而,不执行介质恢复,你决定重新在一个新的表空间上创建索引。你将如何操作以减少需要重新创建索引的时间?(选择两个。)
本站文章为和通数据库网友分享或者投稿,欢迎任何形式的转载,但请务必注明出处.
同时文章内容如有侵犯了您的权益,请联系QQ:970679559,我们会在尽快处理。