July 21, 2013March 4, 2023cesardbaLeave a Comment

Rebuild de Index Inválido

SELECT 'ALTER INDEX'||' '|| OWNER||'.'||INDEX_NAME||' REBUILD TABLESPACE '||'GJAV_INDEX;' FROM dba_indexes
WHERE status LIKE 'UNUSABLE';

SQL