Shulou(Shulou.com)06/01 Report--

Automatic reconstruction of failed index shell script how to write, I believe that many inexperienced people do not know what to do, so this article summarizes the causes of the problem and solutions, through this article I hope you can solve this problem.

Automatically rebuild the shell script of the failed index

The script runs every hour to detect the invalid index and rebuild it as soon as it is found.

The full content of the script is as follows:

[oracle@orac1 pump] $more / home/oracle/tools/rebuild_index.sh

# Enviroment define.

Source / home/oracle/tools/SET_JOB_ENV.sh

Export PATH=$PATH

# following is excution part

Sqlplus / as sysdba

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.