Oracle DBA Blog
Friday, May 20, 2011
Rebuilding Indexes
select 'ALTER INDEX '|| index_name ||' REBUILD TABLESPACE INDX;’ from USER_INDEXES -- TO GET ALL THE INDEXES
alter system enable restricted session;
Run the indexes rebuild script
alter system disable restricted session;
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment