Friday, January 22, 2016

ora-01502 index unusable state

SELECT 'ALTER INDEX '||OWNER||'.'||INDEX_NAME||' REBUILD;'
FROM DBA_INDEXES
WHERE STATUS = 'UNUSABLE';

No comments:

Post a Comment

Followers