Skip Headers
Oracle® Warehouse Builder OMB*Plus Command Reference
11g Release 2 (11.2)

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

OMBCREATE IMPORT_ACTION_PLAN

Purpose

To create a transient import action plan.

Prerequisites

In the context of a project.

Syntax

createImportActionPlanCommand =  ( OMBCREATE TRANSIENT IMPORT_ACTION_PLAN 
          "QUOTED_STRING" { "addActionClause" } )
     addActionClause =  ADD ACTION "QUOTED_STRING" ( "setPropertiesClause" [ 
          "setRefSourceAndTargetClause" ] | "setRefSourceAndTargetClause" )
     setPropertiesClause =  SET PROPERTIES "(" "propertyNameList" ")" VALUES "("
           "propertyValueList" ")"
     setRefSourceAndTargetClause =  SET ( REF | REFERENCE ) "sourcesClause" SET 
          ( REF | REFERENCE ) "targetClause"
     propertyNameList =  "UNQUOTED_STRING" { "," "UNQUOTED_STRING" }
     propertyValueList =  "propertyValue" { "," "propertyValue" }
     sourcesClause =  SOURCE "ObjType" "QUOTED_STRING" [ SET ( REF | REFERENCE )
           "sourcesClause" ]
     targetClause =  TARGET "ObjType" "QUOTED_STRING"
     propertyValue =  ( "QUOTED_STRING" | "INTEGER_LITERAL" | 
          "FLOATING_POINT_LITERAL" )

Parameters

createImportActionPlanCommand

This command is for creating a transient import action plan, which is composed of a set of import actions. Each import action includes specification of source objects from which metadata will be extracted and one target object, into which the metadata will be added.

QUOTED_STRING

The name of the import action plan to be created.

addActionClause

For adding an action to the import action plan.

QUOTED_STRING

The name of the action to be added.

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.

sourcesClause

For specifying source objects in an import action. Valid object types are as follows.

TABLE

VIEW

SEQUENCE

MATERIALIZED_VIEW

EXTERNAL_TABLE

ADVANCED_QUEUE

QUEUE_TABLE

OBJECT_TYPE

VARRAY

NESTED_TABLE

DIMENSION

CUBE

FUNCTION

PROCEDURE

PACKAGE

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'.

For importing into a transportable module, the object specification requires an optional tablespace name qualifier, such as 'USERS.SCOTT.EMP' or 'DEFAULT.SCOTT.EMP'. The tablespace name is required because schemas are listed under tablespaces in the transportable module tree in OWB designer console. If 'DEFAULT' is specified as tablespace name, then the default tablespace name of the schema is used. If the tablespace name is ommitted, then the following rule is used to deduce the appropriate tablespace name.

First, if the object is a database segment (i.e., table and materialized view), then use the tablespace name of the tablespace where the segment resides.

Second if the object is not a database segment, then the default tablespace name for the schema is used, i.e., it is equivalent to specifying 'DEFAULT' as tablespace name.

targetClause

For specifying the target object in an import action. There can only be one target object in an import action.

QUOTED_STRING

The name of the target object.

See Also

OMBIMPORT