Skip Headers
Oracle® Warehouse Builder OMB*Plus Command Reference
11g Release 2 (11.2)

Part Number E14406-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
Mobi · ePub

OMBSEED

Purpose

Seed OWB repository schema OWBSYS.

Prerequisites

To seed OWB repository schema OWBSYS, within the same OMBPlus session, no other OMB commands should be issued before or after the OMBSEED command. Also, before issuing this command, OWBSYS user schema needs to be created either through 11g database installation or by executing script 'cat_owb.sql' manually. The value of OWB_SERVER_HOME_CHECK_FLAG can be set to either TRUE or FALSE. If OWB_SERVER_HOME_CHECK_FLAG is set to TRUE, OWB_SERVER_ORACLE_HOME must be provided as a valid path which OWB software is installed. The value of USING CREDENTIAL must be OWBSYS' database user credential.

Syntax

parseSeedWBRepositoryCommand =  OMBSEED [ DATA_TABLESPACE "QUOTED_STRING" ]
           [ INDEX_TABLESPACE "QUOTED_STRING" ] [ TEMPORARY_TABLESPACE 
          "QUOTED_STRING" ] [ SNAPSHOT_TABLESPACE "QUOTED_STRING" ] [ 
          BASE_LANGUAGE "QUOTED_STRING" ] [ SUPPORTED_LANGUAGES "(" 
          "QUOTED_STRING" { "," "QUOTED_STRING" } ")" ] [ OWB_SERVER_ORACLE_HOME
           "QUOTED_STRING" ] [ OWB_SERVER_HOME_CHECK_FLAG "UNQUOTED_STRING" ] 
          USING CREDENTIAL "UNQUOTED_STRING" [ NET_SERVICE_NAME "QUOTED_STRING" 
          ]

Parameters

parseSeedWBRepositoryCommand

Specify an OMBSEED command.

QUOTED_STRING

Specify the tablespace name, language name, OWB Oracle Home, or NET SERVICE NAME. For example: DATA_TABLESPACE 'USERS'

UNQUOTED_STRING

Specify the connection string to the database using this format: OWBSYS/OWBSYS_PASSWORD@HOST:PORT:SERVICE_NAME