|
Oracle Warehouse Builder 10g |
| Scripting Language - Product Setup |
The installation section describes how you can set up the Warehouse Builder components of your system once you have installed the software.
Table of contents
OMBINSTALL DESIGNTIME_REPOSITORY
To automate or make the install of a repository infinitely reproducible you can write a script that sets up an entire environment. The first step is to install the design repository.
To install the design repository from an OMB Plus session you must ensure that you do not run any OMB commands before or after the install command! Note that this includes connecting. You should not connect, just start with the following command:
OMBINSTALL DESIGNTIME_REPOSITORY sc_test/sc_test \
USING CREDENTIAL sys/change_on_install@localhost:1521:orcl92
Once the repository has been created you should see the following text (this may take a while):
Design repository has been installed.
You can of course set the storage tablespaces for the repository objects. This is done in the statement below (note this again creates the sc_test repository, so do not run both scripts in one session):
OMBINSTALL DESIGNTIME_REPOSITORY sc_test/sc_test \
DATA_TABLESPACE 'OWB92_TAB' \
INDEX_TABLESPACE 'OWB92_IND' \
TEMPORARY_TABLESPACE 'TEMP' \
SNAPSHOT_TABLESPACE 'OWB92_TAB' \
BASE_LANGUAGE 'AMERICAN_ENGLISH' \
SUPPORTED_LANGUAGES ('DUTCH') \
USING CREDENTIAL sys/change_on_install@localhost:1521:orcl92
If you combine the design repository installation with the next steps, you can setup your entire environment from a script. For a list of all supported languages see the Scripting Reference Guide.
Back to Top
OMBINSTALL RUNTIME_REPOSITORY
You can install the runtime repository from the scripting environment. This allows you to automate this step, or let's you adhere to naming conventions by always using these scripts.
OMBINSTALL RUNTIME_REPOSITORY RTR/RTR \
RUNTIME_ACCESS_USER RTU/RTU \
DATA_TABLESPACE 'OWB92_RT_TAB' \
INDEX_TABLESPACE 'OWB92_RT_IND' \
USING CREDENTIAL sys/change_on_install@localhost:1521:orcl92
To link your runtime repository to your design repository you must create a Runtime Repository Connection.
Back to Top
OMBINSTALL TARGET_SCHEMA
Most systems consist of multiple target schemas managed by a central runtime repository. With this option you can automate and streamline the creation of a new target schema.
OMBINSTALL TARGET_SCHEMA RT/RT \
DATA_TABLESPACE 'OWB92_RT_TAB' \
INDEX_TABLESPACE 'OWB92_RT_IND' \
USING RUNTIME_REPOSITORY RTR/RTR \
USING CREDENTIAL sys/change_on_install@localhost:1521:orcl92
As you need to link a target to a runtime repository it is mandatory to install the runtime repository first. Then you can create as many targets as you want provided they are all linked to a runtime repository. You can install a target with specific settings like tablespaces or leave these out. Simply omit the TABLESPACE entries in the example.
Bookmark
