Syntax
alterImportActionPlanCommand = ( OMBALTER ( IMPORT_ACTION_PLAN )
"QUOTED_STRING" ( "alterActionPlanClause" { "alterActionPlanClause" }
) )
alterActionPlanClause = "renameActionPlanClause" | "addActionClause" |
"deleteActionClause" | "modifyActionClause"
renameActionPlanClause = RENAME TO "QUOTED_STRING"
addActionClause = ADD ACTION "QUOTED_STRING" ( "setPropertiesClause" [
"setRefSourceAndTargetClause" ] | "setRefSourceAndTargetClause" )
deleteActionClause = DELETE ACTION "QUOTED_STRING"
modifyActionClause = MODIFY ACTION "QUOTED_STRING" "modifyActionOperation"
{ "modifyActionOperation" }
setPropertiesClause = SET PROPERTIES "(" "propertyNameList" ")" VALUES "("
"propertyValueList" ")"
setRefSourceAndTargetClause = SET ( REF | REFERENCE ) "sourcesClause" SET
( REF | REFERENCE ) "targetClause"
modifyActionOperation = "renameActionClause" | "setPropertiesClause" |
"setRefSourceClause" | "setRefTargetClause" | "deleteSourceClause" |
"unsetTargetReferenceClause"
propertyNameList = "UNQUOTED_STRING" { "," "UNQUOTED_STRING" }
propertyValueList = "propertyValue" { "," "propertyValue" }
sourcesClause = SOURCE "ObjType" "QUOTED_STRING" [ SET ( REF | REFERENCE )
"sourcesClause" ]
targetClause = TARGET "ObjType" "QUOTED_STRING"
renameActionClause = RENAME TO "QUOTED_STRING"
setRefSourceClause = SET ( REF | REFERENCE ) "sourcesClause"
setRefTargetClause = SET ( REF | REFERENCE ) "targetClause"
deleteSourceClause = UNSET ( REF | REFERENCE ) SOURCE "ObjType"
"QUOTED_STRING"
unsetTargetReferenceClause = UNSET ( REF | REFERENCE ) TARGET
propertyValue = ( "QUOTED_STRING" | "INTEGER_LITERAL" |
"FLOATING_POINT_LITERAL" )
Parameters
alterImportActionPlanCommand
This command is for changing the details of an existing import action plan.
QUOTED_STRING
The name of the transient import action plan to be altered.
alterActionPlanClause
One modification to the import action plan.
renameActionPlanClause
For renaming the action plan.
QUOTED_STRING
The new name for the import action plan.
addActionClause
For adding an action to the import action plan.
QUOTED_STRING
The name of the action to be added.
deleteActionClause
For deleting an existing action.
QUOTED_STRING
The name of the action to be deleted.
modifyActionClause
For changing details of an existing action in the import action plan.
setPropertiesClause
For setting any properties for the import action. For the current release, there are no predefined property for import actions.
setRefSourceAndTargetClause
For specifying source and target objects for the import action. The source objects are to be imported into target.
modifyActionOperation
The clause for modifying details of an action.
renameActionClause
For renaming the action.
QUOTED_STRING
The new name for the action.
deleteSourceClause
For deleting a source item from the list of source items of this action.
QUOTED_STRING
The name of the source object. Note that the name of the source object must be qualified with schema name, such as 'SCOTT.EMP'.
unsetTargetReferenceClause
For removing the pointer to target object from the import action.
