Tuesday, 14 July 2015

how to rebuild the index?

alter index  <index_name>  rebuild;

alter index  <index_name>  rebuild online;

ex: Alter index  j_index  rebuild;

ex: Alter index  j_index  rebuild  online;

No comments:

Post a Comment

Query to find request set and its responsibility

  SELECT FA.application_name,        fr.responsibility_name program_attached_to,        frg.request_group_name,        fcp.request_set_name,...