September 8, 2011 archive

Sep 08

ORA-1031 EXEC IMMED Rebuild Index

I recently ran into a problem that did not make any sense until I delved into a a bit further. I had a stored procedure which did an online index rebuild: CREATE PROCEDURE scott.rebuild_idx_proc AS BEGIN EXEC IMMED ‘ALTER INDEX scott.emp_pk REBUILD ONLINE’; END; / The artery which carries blood to the penis is very …

Continue reading