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
Mobi · ePub

OMBALTER CMI_DEFINITION

Purpose

Alter the CMI definition by renaming it, and/or reset its properties.

Prerequisites

Should be in the root context.

Syntax

alterMIVDefinitionCommand =  OMBALTER ( CMI_DEFINITION "QUOTED_STRING" ( 
          "renameClause" [ SET "setPropertiesClause" ] | ( SET 
          "setPropertiesClause" ) | ( USING DEFINITION_FILE "QUOTED_STRING" ) ) 
          )
     renameClause =  RENAME TO "QUOTED_STRING"
     setPropertiesClause =  PROPERTIES "(" "propertyNameList" ")" VALUES "(" 
          "propertyValueList" ")"
     propertyNameList =  "UNQUOTED_STRING" { "," "UNQUOTED_STRING" }
     propertyValueList =  "propertyValue" { "," "propertyValue" }
     propertyValue =  ( "QUOTED_STRING" | "INTEGER_LITERAL" | 
          "FLOATING_POINT_LITERAL" )

Parameters

alterMIVDefinitionCommand

This command modifies an existing CMI definition.

QUOTED_STRING

Name of the existing CMI definition in single quotes.

renameClause

Rename an CMI definition.

setPropertiesClause

Associate a set of properties with the existing CMI definition.

setPropertiesClause

Basic properties for CMI_DEFINITION:

Name: BUSINESS_NAME
Type: STRING(200)
Valid Values: Any valid character string in supported character set.
Default: NAME
Business name of an CMI Definition 

Name: DESCRIPTION
Type: STRING(4000)
Valid Values: Any valid character string in supported character set.
Default: Empty string
Description of an CMI Definition

Name: MIV_TYPE
Type: STRING(40)
Valid Values: Applications,Databases
Default: N/A
Type of an CMI Definition

propertyNameList

Comma separated list of property names. Property names are unquoted.

propertyValueList

Comma separated list of property values.

propertyValue

Value of a property.

CMI_DEFINITION Object

Table 1-9 CMI_DEFINITION Object

Property Type Choices Min Max Default Description

LOCATION_UOID

STRING

none

none

none

empty string

Location Warehouse Builder should use to retrieve the data.