/DetectorDescription/OnlineDBLoader/scripts/CMS_DTCTR_GEOMETRY_OWNER/loading-scripts/load_all_tables.sh

 1#!/bin/sh
 2# This script load all the tables in DGD using sqlldr.
 3# Yuyi Guo May 13, 2005 
 4#
 5
 6echo -n 'database TNS name: '
 7read DB_NAME
 8echo -n 'schema writer name: '
 9read USER_NAME
10echo -n 'schema writer password: '
11read PASSWD
12CONN_ID=$USER_NAME@$DB_NAME/$PASSWD
13#echo "$CONN_ID" 
14
15echo 'Loading Table SOLIDS' 
16sqlldr $CONN_ID control=solids.ctl log=solids.log
17
18#echo 'Loading Table boxes'
19sqlldr $CONN_ID control=boxes.ctl log=boxes.log
20
21#echo 'Loading Table trapezoids '
22sqlldr $CONN_ID control=trapezoids.ctl log=trapezoids.log
23
24#echo 'Loading Table trapezoids '
25sqlldr $CONN_ID control=pseudotraps.ctl log=pseduotraps.log
26
27#echo 'Loading Table cones '
28sqlldr $CONN_ID control=cones.ctl log=cones.log
29
30#echo 'Loading Table  polyhedras'
31sqlldr $CONN_ID control=polyhedras.ctl log=polyhedras.log
32
33#echo 'Loading Table polycones'
34sqlldr $CONN_ID control=polycones.ctl log=polycones.log
35
36#echo 'Loading Table tubesections'
37sqlldr $CONN_ID control=tubesections.ctl log=tubesections.log
38
39#echo 'Loading Table trd1s '
40sqlldr $CONN_ID control=trd1s.ctl log=trd1s.log
41
42#echo 'Loading Table rotations '
43sqlldr $CONN_ID control=rotations.ctl log=rotations.log
44
45#echo 'Loading Table booleansolids '
46sqlldr $CONN_ID control=booleansolids.ctl log=booleansolids.log
47
48#echo 'Loading Table zsections'
49sqlldr $CONN_ID control=zsections.ctl log=zsections.log
50
51#echo 'Loading Table materials'
52sqlldr $CONN_ID control=materials.ctl log=materials.log
53
54#echo 'Loading Table  compositematerials '
55sqlldr $CONN_ID control=compositematerials.ctl log=compositematerials.log
56
57#echo 'Loading Table elementarymaterials '
58sqlldr $CONN_ID control=elementarymaterials.ctl log=elementarymaterials.log
59
60#echo 'Loading Table materialfractions'
61sqlldr $CONN_ID control=materialfractions.ctl log=materialfractions.log
62
63#echo 'Loading Table categories '
64sqlldr $CONN_ID control=categories.ctl log=categories.log
65
66#echo 'Loading Table logicalparttypes & detectorparts'
67sqlldr $CONN_ID control=logicalparts.ctl log=logicalparts.log
68sqlldr $CONN_ID control=detectorparts.ctl log=detectorparts.log
69
70#echo 'Loading Table  pospartsgraph & replacements '
71sqlldr $CONN_ID control=pospartsgraph.ctl log= pospartsgraph.log
72
73#echo 'Loading Table  physicalpartstree '
74sqlldr $CONN_ID control=physicalpartstree.ctl log=physicalpartstree.log
75
76#echo 'Loading Table nominalplacements '
77sqlldr $CONN_ID control=nominalplacements.ctl log=nominalplacements.log