search

littlecowk35 / eic-quan-ly-cong-van

Automatically exported from code.google.com/p/eic-quan-ly-cong-van
0 stars 0 forks source link

How to fix Unsuable index in Oracle #9

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
http://www.orafaq.com/wiki/Unusable_indexes

Original issue reported on code.google.com by ntanh...@gmail.com on 6 Aug 2014 at 5:46

GoogleCodeExporter commented 9 years ago 
SELECT owner, index_name, tablespace_name
FROM   dba_indexes
WHERE  status = 'UNUSABLE';

SELECT 'alter index '||index_name||' rebuild tablespace '||tablespace_name ||';'
FROM   dba_indexes
WHERE  status = 'UNUSABLE';

Original comment by ntanh...@gmail.com on 6 Aug 2014 at 5:46

GoogleCodeExporter commented 9 years ago

Original comment by ntanh...@gmail.com on 14 Aug 2014 at 1:28