title: Oracle Trigger to rebuild an Index
body: <p>How can I create a trigger in Oracle to rebuild an index?  </p>
  
  <pre><code>create or replace  
   TRIGGER BI_NAME_SEARCH AFTER INSERT OR UPDATE ON PROFILE
  FOR EACH ROW  
  BEGIN  
     ALTER INDEX MYINDEX REBUILD;  
  END;
  </code></pre>
  
  <p>This is not working.</p>