Friday, May 17, 2013

How to rebuild index in oracle

SELECT 'ALTER INDEX ' || a.index_name || ' REBUILD;'
FROM   all_indexes a
WHERE      table_owner = Upper('TEST')

No comments:

Post a Comment