OMBEXPORT

Purpose

Exports current metadata, metadata definitions, or snapshot metadata to a metadata loader file.

Prerequisites

Connection must be established to repository to be exported from.

Syntax

mdlExportCommand =  ( [ TO ] MDL_FILE "QUOTED_STRING" [ "fileFormatClause" 
          ] [ FROM ] [ "projectClause" ] [ "componentsClause" ] [ ( 
          "classesClause" | ALL_CLASS_DEFINITIONS ) ] [ WITH ] [ 
          "dependeeDepthClause" ] [ "includeGrantsClause" ] [ 
          "includeCMIDefsClause" ] [ "useFieldSeparatorClause" ] [ 
          "controlFileClause" ] [ "includeUserDefsClause" ] [ 
          "supportedLangsClause" ] [ "outputLogClause" ] )
     fileFormatClause =  FILE_FORMAT ( ZIP | TEXT )
     projectClause =  PROJECT "QUOTED_STRING"
     componentsClause =  COMPONENTS "(" "componentsList" ")"
     classesClause =  CLASS_DEFINITIONS "(" "QUOTED_STRING" { "," 
          "QUOTED_STRING" } ")"
     dependeeDepthClause =  DEPENDEE_DEPTH ( MAX | "INTEGER_LITERAL" )
     includeGrantsClause =  INCLUDE_GRANTS
     includeCMIDefsClause =  INCLUDE_CMI_DEFINITIONS
     useFieldSeparatorClause =  [ USE ] FIELD_SEPARATOR "UNQUOTED_STRING"
     controlFileClause =  CONTROL_FILE "QUOTED_STRING"
     includeUserDefsClause =  INCLUDE_USER_DEFINITIONS
     supportedLangsClause =  SUPPORTED_LANGUAGES "(" "supportedLangsList" ")"
     outputLogClause =  OUTPUT LOG [ TO ] "QUOTED_STRING"
     componentsList =  "objectTypeValue" "QUOTED_STRING" { "," "objectTypeValue"
           "QUOTED_STRING" }
     supportedLangsList =  "QUOTED_STRING" { "," "QUOTED_STRING" }
     objectTypeValue =  "UNQUOTED_STRING"

Parameters

mdlExportCommand

Export metadata from an Oracle Warehouse Builder repository to a file.

QUOTED_STRING

Enclose the name of the export metadata file in single quotes.

ALL_CLASS_DEFINITIONS

Exports all the metadata definitions belonging to a workspace.

fileFormatClause

Specify the file format for the exported file.

ZIP

Defaults to a ZIP file format which is a compressed binary file.

TEXT

Readable file format.

projectClause

Specify the project to be exported.

QUOTED_STRING

Enclose the name of the project to be exported in single quotes.

componentsClause

List components to be exported.

classesClause

List of class definitions to be exported.

QUOTED_STRING

Enclose in single quotes the class definition name.

dependeeDepthClause

Specify how many levels of dependent objects should be exported for components specified for export. Use MAX for all dependents, 0 for no dependents, 1 for one level of dependents. The default is 0.

includeGrantsClause

Use to request that security related metadata be included in the export.

includeCMIDefsClause

Use to request that related CMI Definitions for CMI Modules be included in the export.

useFieldSeparatorClause

Do not use this option. It is an obsolete option that was used to specify character to be used as the field separator in the old metadata file format.

UNQUOTED_STRING

Do not use this option. Obsolete metadata file field separator for old MDL file format. Use BAR or CARAT. The default is BAR.

controlFileClause

Specify a control file with export options not directly supported by OMBEXPORT command.

QUOTED_STRING

Enclose the control file name in single quotes.

includeUserDefsClause

Use to request that metadata definitions be included in the export.

supportedLangsClause

List supported languages to be exported.

outputLogClause

Export log file for export messages and statistics.

QUOTED_STRING

Enclose the log file name in single quotes.

componentsList

Comma separated list of components to be exported.

QUOTED_STRING

Enclose in single quotes the absolute or relative path name of an object (e.g. 'MODULE_X/TABLE_Y').

supportedLangsList

Comma separated list of supported languages to be exported.

QUOTED_STRING

Language name or ISO id of supported language (e.g. 'German' or 'de_DE').

objectTypeValue

Specify the first class object type to be exported (e.g. TABLE, VIEW, CUBE, DIMENSION, etc.).

OMBEXPORT

Purpose

Prerequisites

Syntax

Parameters

mdlExportCommand

QUOTED_STRING

ALL_CLASS_DEFINITIONS

fileFormatClause

ZIP

TEXT

projectClause

QUOTED_STRING

componentsClause

classesClause

QUOTED_STRING

dependeeDepthClause

includeGrantsClause

includeCMIDefsClause

useFieldSeparatorClause

UNQUOTED_STRING

controlFileClause

QUOTED_STRING

includeUserDefsClause

supportedLangsClause

outputLogClause

QUOTED_STRING

componentsList

QUOTED_STRING

supportedLangsList

QUOTED_STRING

objectTypeValue

See Also