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
 

OMBALTER SNAPSHOT

Purpose

A snapshot can be altered to remove, add or update components.

Prerequisites

The snapshot to be altered should already exist. This command can be executed for any component regardless of current context.

Syntax

parseAlterCommand =  OMBALTER "alterSnapshotCommand"
     alterSnapshotCommand =  ( SNAPSHOT "QUOTED_STRING" ( SET 
          "setPropertiesClause" | ( ( ( ADD | MODIFY ) "objectClause" ) | ( 
          DELETE "UNQUOTED_STRING" "QUOTED_STRING" ) )+ ) )
     setPropertiesClause =  PROPERTIES "(" "propertyNameList" ")" VALUES "(" 
          "propertyValueList" ")"
     objectClause =  "UNQUOTED_STRING" "QUOTED_STRING" [ CASCADE | NO CASCADE ]
     propertyNameList =  "UNQUOTED_STRING" { "," "UNQUOTED_STRING" }
     propertyValueList =  "propertyValue" { "," "propertyValue" }
     propertyValue =  ( "QUOTED_STRING" | "INTEGER_LITERAL" | 
          "FLOATING_POINT_LITERAL" )

Parameters

parseAlterCommand

Root production for OMBALTER SNAPSHOT.

alterSnapshotCommand

To alter already existing snapshot.

QUOTED_STRING

Name of snapshot to be altered.

ADD

Add components to snapshot.

MODIFY

Replace an already existing component with the latest definition of the component from workspace.

DELETE

Remove component from snapshot.

setPropertiesClause

Properties of snapshot can be altered through this optional clause. Properties of Snapshot is DESCRIPTION and TYPE. Altering TYPE property is an irreversible operation. Altering snapshot from FULL to SIGNATURE will only keep information required for comparing. SIGNATURE snapshots cannot be exported.

getPropertiesClause

Basic properties for SNAPSHOT: 

Name: TYPE
Type: STRING(200)
Valid Values: FULL,SIGNATURE
Default: FULL
This is the type of snapshot 

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

objectClause

Component clause, syntax is same as in CREATE SNAPSHOT command. For the ADD and MODIFY operation, this must be the relative path to the component within the current workspace. For the DELETE operation, this must be the fully-qualified path of the component within a snapshot. Use OMBRETRIEVE SNAPSHOT to get the fully-qualified path of the component within the snapshot to be altered.

UNQUOTED_STRING

Type of the component

QUOTED_STRING

Absolute or relative path name of the component

CASCADE

Cascade option for folder components. By default, any folder is snapshotted along with its contents. The NO CASCADE option allows the user to snapshot only the folder object itself along with its associated properties.

propertyNameList

Property names for SNAPSHOT that can be altered.

propertyValueList

List of property values for SNAPSHOT.

propertyValue

Allowable value types for a snapshot property.