Oracle® Warehouse Builder OMB*Plus Command Reference 11g Release 2 (11.2) Part Number E14406-01 |
|
|
Mobi · ePub |
The snapshot to be altered should already exist. This command can be executed for any component regardless of current context.
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" )
Replace an already existing component with the latest definition of the component from workspace.
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.
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
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.