'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.