'ALTER INDEX ' || C_Indices.INDEX_NAME ||' REBUILD ';
'ALTER INDEX ' || C_Indices.INDEX_NAME || ' REBUILD ONLINE COMPUTE STATISTICS';
In my stored procedure , i am reconstructing or you can say re-building the tables and table name is the input parameter to the procedure.
In middle of the code , i am using execute immediate while running the second alter index (as shown above)..., Its not working and going into exception block, But when i am running the first one , code is moving smoothly.
What can be the possible reasons , Please suggest.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!