OMBUPGRADEREPOS

Purpose

Upgrade Oracle Warehouse Builder repository to the current release.

Prerequisites

Upgrade the Oracle Warehouse Builder repository from 10g Release 2 or 11g Release 1 to the current release of Oracle Warehouse Builder. An OWBSYS schema must exist prior to upgrading the Oracle Warehouse Builder repository. The USING CREDENTIAL value must be from an OWBSYS database user. If upgrading from Oracle Warehouse Builder 10g Release 2, you must also specify the REPOSITORY_OWNER credential.

Syntax

parseUpgradeRepositoryCommand =  ( OMBUPGRADEREPOSITORY | OMBUPGRADEREPOS )
           [ [ TO ] MDL_FILE "QUOTED_STRING" ] [ OUTPUT LOG [ TO ] 
          "QUOTED_STRING" ] USING CREDENTIAL "UNQUOTED_STRING" [ 
          NET_SERVICE_NAME "QUOTED_STRING" ] [ USING REPOSITORY_OWNER CREDENTIAL
           "UNQUOTED_STRING" ]

Parameters

parseUpgradeRepositoryCommand

Upgrade an Oracle Warehouse Builder repository from a previous release to the current release.

UNQUOTED_STRING

Specify the credential in the format: USERNAME/PASSWORD@HOST:PORT:SERVICE_NAME