OMBEXPORT ENTIRE_REPOSITORY

Purpose

Exports the entire Oracle Warehouse Builder repository to a metadata loader file.

Prerequisites

You must not be connected to a design repository. If connected, then use OMBDISCONNECT to disconnect.

This command only supports 10g Release 2 or a later release.

Exporting entire repository from 10g Release 2 requires the repository owner credentials.

Exporting entire repository from 11g or later requires the OWBSYS credentials.

Syntax

repositoryUpgradeExportCommand =  ( ENTIRE_REPOSITORY [ TO ] MDL_FILE 
          "QUOTED_STRING" [ "outputLogClause" ] USING CREDENTIAL 
          "UNQUOTED_STRING" [ NET_SERVICE_NAME "QUOTED_STRING" ] )
     outputLogClause =  OUTPUT LOG [ TO ] "QUOTED_STRING"

Parameters

repositoryUpgradeExportCommand

Export the entire repository metadata to a file.

QUOTED_STRING

= Enclose the name of the exported repository file in single quotes.

UNQUOTED_STRING

Specify the repository credential in the format username/password@host:port:servicename

outputLogClause

Export log file for export messages and statistics.

QUOTED_STRING

Enclose the log file name in single quotes.

OMBEXPORT ENTIRE_REPOSITORY

Purpose

Prerequisites

Syntax

Parameters

repositoryUpgradeExportCommand

QUOTED_STRING

UNQUOTED_STRING

outputLogClause

QUOTED_STRING

See Also