| Revision: | 1.1 |
| Committed: | Wed Oct 5 07:30:46 2005 UTC (19 years, 7 months ago) by lat |
| Branch: | MAIN |
| CVS Tags: | DBS_1_0_0_pre6, DBS_1_0_0_pre5, pre5_v01_00_00, pre4_v01_00_00, pre3_v01_00_00, pre2_v01_00_00, pre_v01_00_00, v00_00_14, v00_00_13, v00_00_12, v00_00_11, v00_00_10, v00_00_09, v00_00_08, v00_00_07, v00_00_06, v00_00_05, v00_00_004, DBS_0_0_3a, DBS_0_0_3, DBS_0_0_2, DBS_0_0_1, pre_DBS_0_0_1, post_dict_type_checking_merge, post_MiniPythonAPI_merged_to_trunk, pre_MiniPythonAPI_merge_to_trunk, DBS_0_0_0, vs20060320, AfterJan2006SchemaChanges_v01_00_01, AfterJan2006SchemaChanges_v01_00_00, AfterJan2006SchemaChanges, BeforeJan2006SchemaChanges, before_message_removal, HEAD |
| Branch point for: | BranchForCPPWebServiceTesting |
| Log Message: | Add script to switch to different Oracle tablespaces. |
| # | Content |
|---|---|
| 1 | #!/bin/sh |
| 2 | |
| 3 | case ${1-Prod} in |
| 4 | Prod ) |
| 5 | echo "$0: Switching schema to \`$1' tablespaces" |
| 6 | perl -p -i -e 's/([ ])INDX01/${1}CMS_DBS_INDX01/g' Oracle*.sql ;; |
| 7 | Dev ) |
| 8 | echo "$0: Switching schema to \`$1' tablespaces" |
| 9 | perl -p -i -e 's/([ ])CMS_DBS_INDX01/${1}INDX01/g' Oracle*.sql ;; |
| 10 | * ) |
| 11 | echo "$0: Sorry, don't know how to switch to tablespace for \`$1'" 1>&2 |
| 12 | exit 1;; |
| 13 | esac |