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 MDL_FILE

Purpose

Imports metadata and metadata definitions from a Metadata Loader file.

Prerequisites

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

Syntax

mdlImportCommand =  ( MDL_FILE "QUOTED_STRING" [ "noUpgradeClause" ] [ 
          "includeUserDefsClause" ] [ "useModeClause" | "asSnapshotClause" ] [ 
          "matchByClause" ] [ "includeGrantsClause" ] [ "includeCMIDefsClause" ]
           [ "controlFileClause" ] [ "supportedLangsClause" ] [ 
          "allowDiffBaseLangClause" ] [ "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"
     modeValue =  ( CREATE_MODE | REPLACE_MODE | UPDATE_MODE | MERGE_MODE )
     matchByValue =  ( UNIVERSAL_IDENTIFIER | NAMES )
     supportedLangsList =  "QUOTED_STRING" { "," "QUOTED_STRING" }

Parameters

mdlImportCommand

Import metadata from a file.

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.

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').