FDA/ 0000755 0007306 0001604 00000000000 11211356014 010522 5 ustar anogupta g900 FDA/Schema/ 0000755 0007306 0001604 00000000000 11211356004 011721 5 ustar anogupta g900 FDA/Schema/schema.sh 0000755 0007306 0001604 00000000523 11211356004 013520 0 ustar anogupta g900 #!/bin/ksh
echodo ()
{
echo $*
$*
}
if [ "$#" -lt "1" ]
then
echo "Usage: $0
"
exit
fi
DB=$ORACLE_SID
DB_DIR=$1
echodo ./schema_C.sh ${DB} ${DB_DIR}
echodo ./schema_M.sh ${DB} ${DB_DIR}
echodo ./schema_O.sh ${DB} ${DB_DIR}
echodo ./schema_S.sh ${DB} ${DB_DIR}
echodo ./schema_U.sh ${DB} ${DB_DIR}
FDA/Schema/schema_M.sh 0000755 0007306 0001604 00000007042 11211356004 013777 0 ustar anogupta g900 #!/bin/sh
#
# Copyright (c) 2004 Standard Performance Evaluation Corporation (SPEC)
# All rights reserved.
#
# $Id: schema_M.sh,v 1.3 2004/04/21 13:51:22 skounev Exp $
#
# Script to create mfg database
# Tom Daly Jan 2000
# modify script to build mfg specific
# tables and tablespaces against an existing database
# This is to allow all of spec to run on one database
# which will allow for easier testing and installation.
# schema_M.sh now takes database name and database directory
# parameters.
# Note: The database must now exist, refer to the createdb.sh script
# to build the database prior to running this script.
#
# April 2003 Balu Sthanikam: Updated for SJAS2004 and other changes.
if [ "$ORACLE_HOME" = "" ]
then
echo "$ORACLE_HOME"
echo "You must set the ORACLE_HOME environment variable"
exit 1
fi
if [ $# -ne 2 ]
then
echo "Usage: schema_M.sh "
exit 1
fi
DB=$1
DB_DIR=$2
ORACLE_SID=$DB
export ORACLE_SID
###### datafiles #####
PART=${DB_DIR}/M_parts
BOM=${DB_DIR}/M_bom
WO=${DB_DIR}/M_wrkorder
WO_IDX=${DB_DIR}/M_wrkorder_idx
LO=${DB_DIR}/M_lrgorder
INV=${DB_DIR}/M_inv
INV_IDX=${DB_DIR}/M_inv_idx
#sqlplus <