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

Purpose

Alter metadata for a component.

Prerequisites

Should be in the parent context of the component to alter.

Syntax

alterCommand =  OMBALTER "fco_type" "fco_name" "alterCommandSubClauses"
     alterCommandSubClauses =  ( "renameClause" [ "setPropertiesClause" ] { 
          "setReferenceClause" | "unsetReferenceClause" } { 
          "addSCOClauseForAlter" | "modifySCOClause" | "deleteSCOClause" } ) | (
           "setPropertiesClause" { "setReferenceClause" | "unsetReferenceClause"
           } { "addSCOClauseForAlter" | "modifySCOClause" | "deleteSCOClause" } 
          ) | ( ( "setReferenceClause" | "unsetReferenceClause" )+ { 
          "addSCOClauseForAlter" | "modifySCOClause" | "deleteSCOClause" } ) | (
           "addSCOClauseForAlter" | "modifySCOClause" | "deleteSCOClause" )+
     renameClause =  RENAME TO "QUOTED_STRING"
     setPropertiesClause =  SET PROPERTIES "(" "propertyNameList" ")" VALUES "("
           "propertyValueList" ")"
     setReferenceClause =  SET ( REF | REFERENCE ) [ "qualifier" ] "type" 
          "quotedNameList" [ { "parentSCOClause" } OF "fco_type" "fco_name" ]
     unsetReferenceClause =  UNSET ( REF | REFERENCE ) [ "qualifier" ] "type"
     addSCOClauseForAlter =  ADD "sco_type" "sco_name" { "parentSCOClause" } [ 
          AT POSITION "pos" ] [ "setPropertiesClause" ] { "setReferenceClause" }
     modifySCOClause =  MODIFY "sco_type" "sco_name" { "parentSCOClause" } 
          "modifySCOSubClauses"
     deleteSCOClause =  DELETE "sco_type" "sco_name" { "parentSCOClause" }
     propertyNameList =  "propertyName" { "," "propertyName" }
     propertyValueList =  "propertyValue" { "," "propertyValue" }
     quotedNameList =  "QUOTED_STRING" | "(" "QUOTED_STRING" { "," 
          "QUOTED_STRING" } ")"
     parentSCOClause =  OF "sco_type" "sco_name"
     modifySCOSubClauses =  ( "renameClause" [ "moveToClause" ] [ 
          "setPropertiesClause" ] { "setReferenceClause" } ) | ( "moveToClause" 
          [ "setPropertiesClause" ] { "setReferenceClause" } ) | ( 
          "setPropertiesClause" { "setReferenceClause" } ) | 
          "setReferenceClause"+
     propertyName =  "UNQUOTED_STRING"
     propertyValue =  "QUOTED_STRING" | "INTEGER_LITERAL" | 
          "FLOATING_POINT_LITERAL"
     moveToClause =  MOVE TO POSITION "pos"

Parameters

alterCommand

Specify the component to alter.

fco_type

The type of the component.

fco_name

The physical name of the component in single quotes.

alterCommandSubClauses

Use this clause to rename the component, reset its properties, or modify the child objects of the component.

renameClause

Rename the component.

setPropertiesClause

Set object properties.

setReferenceClause

Specify reference objects.

qualifier

Specify which reference to set, if there are more than one pointing to the same type.

unsetReferenceClause

Removes an existing reference.

qualifier

Specify which reference to set, if there are more than one pointing to the same type.

addSCOClauseForAlter

Add child objects under the component.

modifySCOClause

Change definition of a child object.

deleteSCOClause

Delete a child object.

propertyNameList

A list of property names.

propertyValueList

A list of property values.

quotedNameList

A list of single-quoted physical names.

parentSCOClause

Used to specify the path from a child object to the component

modifySCOSubClauses

Use this clause to rename a child object, reset its properties or references, or reorder it.

propertyName

An unquoted string representing the name of a property.

propertyValue

The value of a property.

moveToClause

Used to reorder child objects.

See Also

OMBCREATE

OMBDROP