#!/bin/sh
#*******************************************************************************
#             ISTP REENGENEERING
#         ORACLE RECONSTRUCTION RULES
#               NASA/GSFC
#*******************************************************************************
#PURPOSE: Creates the indices for the Oracle Rules Tables.
#
#INVOCATION METHOD: IndexBuilder user/pw Tablespace_name 
#
#
# EXTERNAL VARIABLES:
# Source               Name               Type   Use  Description
# ----------------------------------------------------------------------------
# buildscript          $recon_base        char    I   location of db build scripts
#
#DEVELOPMENT HISTORY:
#
#       Author          Change-ID       Release Date    Description of Change
#       ------          ---------       ------- ----    ---------------------
#       Y. Azie         Build 1              7/8/93   Initial release
#
#NOTES:
#
#*********************************************************************************
if test $# -ne 2 
then
   echo '**********************************************************'
   echo '    Error, you must enter an Oracle UserID/Password '
   echo '    followed by the name of the.tablespace where the'
   echo '    data will be stored.'
   echo '**********************************************************'
   exit
fi

clear

echo ""
echo "**********************************************************"
echo "    Creating Indices for Oracle Reconstruction Tables  "
echo "**********************************************************"


$recon_base/tables/afst.indx                         $1     $2  1024  1024  0  1  unlimited
$recon_base/tables/cdm_mfpt.indx                     $1     $2     2     2  0  1          5
$recon_base/tables/config_parm.indx                  $1     $2  1024  1024  0  1  unlimited
$recon_base/tables/cs_lookupt.indx                   $1     $2     2     2  0  1          5
$recon_base/tables/ifst.indx                         $1     $2  1024  1024  0  1  unlimited
$recon_base/tables/mnffpt.indx                       $1     $2  1024  1024  0  1  unlimited
$recon_base/tables/recipe.indx                       $1     $2  1024  1024  0  1  unlimited
$recon_base/tables/recipe2.indx                      $1     $2  1024  1024  0  1  unlimited
$recon_base/tables/recon_switches.indx               $1     $2  1024  1024  0  1  unlimited
$recon_base/tables/mnfqt.indx                        $1     $2     2     2  0  1  unlimited
$recon_base/tables/rules_numbers.indx                $1     $2  1024  1024  0  1  unlimited
$recon_base/tables/sessions_parameters.indx          $1     $2  1024  1024  0  1  unlimited
$recon_base/tables/trend_time.indx                   $1     $2     2     2  0  1  unlimited

echo "********************************************************************************************"
echo "     DONE building Indices for Oracle Reconstruction.tables - see log file for results"
echo "********************************************************************************************"
echo ""
