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
 

OMBIMPORT

Purpose

Imports metadata from a Metadata Loader file, or from the default metadata location specified in the module.

Please refer to OMBHELP OMBIMPORT MDL_FILE or OMBHELP OMBIMPORT METADATA_LOCATION.

Prerequisites

Must be connected to the workspace where the import is to be performed.

Syntax

ImportCommand =  OMBIMPORT [ FROM ] ( "mdlImportCommand" | 
          "oracleDBImportCommand" | "odiKMImportCommand" | 
          "mdlRepositoryImportCommand" )
     mdlImportCommand =  ( MDL_FILE "QUOTED_STRING" [ "noUpgradeClause" ] [ 
          "includeUserDefsClause" ] [ "useModeClause" | "asSnapshotClause" ] [ 
          "matchByClause" ] [ "includeGrantsClause" ] [ "includeCMIDefsClause" ]
           [ "controlFileClause" ] [ "supportedLangsClause" ] [ 
          "allowDiffBaseLangClause" ] [ "outputLogClause" ] [ 
          "usingCredentialClause" ] [ "netServiceNameClause" ] )
     oracleDBImportCommand =  ( METADATA_LOCATION [ FOR ] IMPORT_ACTION_PLAN 
          "QUOTED_STRING" [ "setImportOptions" ] )
     odiKMImportCommand =  ( CT_FILE "QUOTED_STRING" [ "kmNameClause" ] [ 
          "kmModuleClause" ] )
     mdlRepositoryImportCommand =  ( ENTIRE_REPOSITORY MDL_FILE "QUOTED_STRING" 
          [ "controlFileClause" ] [ "outputLogClause" ] [ 
          "usingCredentialClause" ] [ "netServiceNameClause" ] )
     noUpgradeClause =  NO_UPGRADE
     includeUserDefsClause =  INCLUDE_USER_DEFINITIONS
     useModeClause =  USE "modeValue"
     asSnapshotClause =  AS SNAPSHOT "QUOTED_STRING"
     matchByClause =  MATCH_BY "matchByValue"
     includeGrantsClause =  INCLUDE_GRANTS
     includeCMIDefsClause =  INCLUDE_CMI_DEFINITIONS
     controlFileClause =  CONTROL_FILE "QUOTED_STRING"
     supportedLangsClause =  SUPPORTED_LANGUAGES "(" "supportedLangsList" ")"
     allowDiffBaseLangClause =  ALLOW_DIFFERENT_BASE_LANGUAGE
     outputLogClause =  OUTPUT LOG [ TO ] "QUOTED_STRING"
     usingCredentialClause =  USING CREDENTIAL "UNQUOTED_STRING"
     netServiceNameClause =  NET_SERVICE_NAME "QUOTED_STRING"
     setImportOptions =  SET OPTIONS "(" "optionNameList" ")" VALUES "(" 
          "optionValueList" ")"
     kmNameClause =  CT_NAME "QUOTED_STRING"
     kmModuleClause =  CT_FOLDER_NAME "QUOTED_STRING"
     modeValue =  ( CREATE_MODE | REPLACE_MODE | UPDATE_MODE | MERGE_MODE )
     matchByValue =  ( UNIVERSAL_IDENTIFIER | NAMES )
     supportedLangsList =  "QUOTED_STRING" { "," "QUOTED_STRING" }
     optionNameList =  "UNQUOTED_STRING" { "," "UNQUOTED_STRING" }
     optionValueList =  "optionValue" { "," "optionValue" }
     optionValue =  ( "QUOTED_STRING" | "INTEGER_LITERAL" | 
          "FLOATING_POINT_LITERAL" )

Parameters

ImportCommand

Import metadata from a Metadata Loader file, or from the default metadata location specified in the module.

mdlImportCommand

Import metadata from a file.

oracleDBImportCommand

To import from the default metadata location based on the import action plan.

QUOTED_STRING

The name of the transient action plan.

odiKMImportCommand

Import an ODI knowledge module from a file.

mdlRepositoryImportCommand

Import an entire repository from a metadata loader file.

QUOTED_STRING

Enclose the name of the imported repository file in single quotes.

noUpgradeClause

Specify that MDL files that are not compatible with current repository version should not be automatically upgraded. The default is to automatically upgrade unless this clause is used.

includeUserDefsClause

Use to request that any metadata definitions in the MDL file be imported.

useModeClause

Specify import mode for importing metadata file.

asSnapshotClause

Specify a new snapshot name into which the contents of the MDL file are to be imported. Use this option to import old archive files as snapshots.

QUOTED_STRING

Enclose the new snapshot name in single quotes.

matchByClause

Specify whether import should search for already existing objects using universal identifiers or physical names.

includeGrantsClause

Use to request that security related metadata be imported.

includeCMIDefsClause

Use to request that related CMI Definitions for CMI Modules be imported.

controlFileClause

Specify a control file with import options not directly supported by the OMBIMPORT command.

QUOTED_STRING

Enclose the control file name in single quotes.

supportedLangsClause

List supported languages to be imported.

allowDiffBaseLangClause

Use to specify that MDL files with a different base langugae than that of the import target repository can be imported.

outputLogClause

Log file for import messages and statistics.

QUOTED_STRING

Enclose the log file name in single quotes.

usingCredentialClause

Specify the credential string which is used to connect to the repository.

UNQUOTED_STRING

An unquoted string representing the credential in the format username/password@host:port:servicename.

netServiceNameClause

Specify the net service name which is used to connect to the repository.

QUOTED_STRING

Enclose the net service name in single quotes.

setImportOptions

Currently no import options are available to be set.

kmNameClause

Name assigned to imported code template. A generated name will be used if this is not set.

kmModuleClause

CT folder used to contain the code template. If the module name is prefaced by "PUBIC_PROJECT/" the importer will create/use the ct module in the public project. If the PUBLIC_PROJECT is not set, the ct module created/used will be in the current project. If CT_FOLDER_NAME is not set, then the importer will use ODI_KM in the current project.

modeValue

Import mode. Use CREATE_MODE, REPLACE_MODE, UPDATE_MODE, or MERGE_MODE. The default is CREATE_MODE.

CREATE_MODE: create new metadata only

REPLACE_MODE: replace existing objects only

UPDATE_MODE: replace existing objects and create new metadata

MERGE_MODE: merge existing objects and create new metadata

matchByValue

Use UNIVERSAL_IDENTIFIER or NAMES. The default is UNIVERSAL_IDENTIFIER.

supportedLangsList

Comma separated list of supported languages to be imported.

QUOTED_STRING

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

optionNameList

Comma separated list of option names for import.

UNQUOTED_STRING

An unquoted string representing the name of a option.

optionValueList

Comma separated list of option values for import.

optionValue

The value of an import option.