Oracle Index Batch RESET notes

---a single index reset statement

Alter index INDEXNAME rebuild;

---Querying Data Index object statements

SELECT * from User_indexes;

------The index of the database (the index containing the $ character cannot be rebuilt) bulk generate index Reset statement export, batch execution

Select ' Alter index ' | | index_name| | ' rebuild; ' as SQL from user_indexes where index_name isn't in (select Index_name from user_indexes where index_n Ame like '%$% ');

Oracle Index Batch RESET notes