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 TRANSPORTABLE_MODULE

Purpose

To alter the definision of a transportable module.

Prerequisites

In the context of a project.

Syntax

alterTMCommand =  OMBALTER TRANSPORTABLE_MODULE "QUOTED_STRING" ( 
          "alterTMClause" { "alterTMClause" } )
     alterTMClause =  "renameClause" | "setPropertiesAndLocationsAndIconSet" | 
          "unsetReferenceIconSetClause" | "modifyClause"
     renameClause =  RENAME TO "QUOTED_STRING"
     setPropertiesAndLocationsAndIconSet =  SET ( "setPropertiesClause" | 
          "setSourceLocationClause" | "setTargetLocationClause" | 
          "setReferenceIconSetClause" )
     unsetReferenceIconSetClause =  UNSET ( REF | REFERENCE ) ICONSET
     modifyClause =  MODIFY ( "modifyTablespaceClause" | "modifyDatafileClause" 
          | "modifySchemaClause" )
     setPropertiesClause =  ( PROPERTIES "(" "propertyNameList" ")" VALUES "(" 
          "propertyValueList" ")" )
     setSourceLocationClause =  SOURCE_LOCATION "QUOTED_STRING"
     setTargetLocationClause =  TARGET_LOCATION "QUOTED_STRING"
     setReferenceIconSetClause =  ( REF | REFERENCE ) ICONSET "QUOTED_STRING"
     modifyTablespaceClause =  TRANSPORTABLE_MODULE_TABLESPACE "QUOTED_STRING"
     modifyDatafileClause =  DATAFILE "QUOTED_STRING"
     modifySchemaClause =  TRANSPORTABLE_MODULE_SCHEMA "QUOTED_STRING"
     propertyNameList =  "UNQUOTED_STRING" { "," "UNQUOTED_STRING" }
     propertyValueList =  "propertyValue" { "," "propertyValue" }
     propertyValue =  ( "QUOTED_STRING" | "INTEGER_LITERAL" | 
          "FLOATING_POINT_LITERAL" )

Parameters

alterTMCommand

This command is for altering a transportable module.

QUOTED_STRING

The name of the transportable module to be altered.

alterTMClause

Multiple altering actions can be specified with one OMBALTER TRANSPORTABLE_MODULE command.

renameClause

Change the name of the transportable module

QUOTED_STRING

The new name for the transportable module.

setPropertiesAndLocationsAndIconSet

Set properties for the transportable module, and/or specify source and target locations, and/or specify icon set for the newly create transportable module.

unsetReferenceIconSetClause

Remove the reference to the icon set.

modifyClause

Change contents within a transportable module.

setPropertiesClause

Set properties for the transportable module.

setPropertiesClause

Basic properties for TRANSPORTABLE_MODULE:

Name: BUSINESS_NAME
Type: STRING(200)
Valid Values: Any valid character string in supported character set.
Default: NAME
Business name of the transportable module

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

setSourceLocationClause

Specify the source location name.

QUOTED_STRING

The name of an already created transportable module source location.

setTargetLocationClause

Specify the target location name.

QUOTED_STRING

The name of an already created transportable module target location.

setReferenceIconSetClause

Set the icon set for the new transportable module.

QUOTED_STRING

The name of the icon set.

modifyTablespaceClause

Modify a tablespace within a transportable module.

QUOTED_STRING

The tablespace name. Note that the tablespace name is its name in the source database.

modifyDatafileClause

Modify a datafile within a transportable module.

QUOTED_STRING

The name of the datafile. Note that the datafile name is its full path name in the source database. The name must be exactly same with what is in DBA_DATA_FILES view in the source database.

modifySchemaClause

Modify a schema within a transportable module.

QUOTED_STRING

The name of the schema. Note that the schema name is its name in the source database.

propertyNameList

The list of unquoted property names.

propertyValueList

The list of property values.

propertyValue

A property value can be a single-quoted string, an integer, or a floating point number.

TRANSPORTABLE_MODULE Object

Table 4-65 TRANSPORTABLE_MODULE Object

Property Type Choices Min Max Default Description

GENERATION_COMMENTS

STRING

none

none

none

empty string

Enter additional comments for the generated code.

TARGET_OS_TYPE

STRING

Linux, Unix, Windows

none

none

Unix

The operating system type of the target machine. This is needed for generating shell scripts in correct style required by the OS.

TRANSPORT_TABLESPACE

BOOLEAN

true, false

none

none

true

Specifies whether transportable tablespace (TTS) feature is to be used for deploying tables in the transportable module. If set to true, tablespaces are copied from source to target using the server TTS mechanism. If set to false, tables are individually extracted and deployed using Oracle Data Pump available in Oracle10g or later; but tablespaces are not transported. Since Oracle Data Pump is new in Oracle 10g, setting this parameter to false is only allowed if both source and target databases are with Oracle 10g or a higher versions.

WHAT_TO_DEPLOY

STRING

ALL_OBJECTS, TABLES_ONLY

none

none

ALL_OBJECTS

Specifies whether only tables in the transportable module are deployed or everything in it is deployed.

WORK_DIRECTORY

STRING

none

none

none

empty string

The full path of work directory on target machine, where temporary files, logs and tablespace datafiles may be stored. If left unspecified, OWB's runtime home directory is used as the work directory. It is highly recommended that users specify dedicated directory for transportable module deployment.


TRANSPORTABLE_MODULE_TABLESPACE Object

Table 4-66 TRANSPORTABLE_MODULE_TABLESPACE Object

Property Type Choices Min Max Default Description

DROP_EXISTING_TABLESPACE

BOOLEAN

true, false

none

none

false

If this parameter is set to true, existing tablespace in target is dropped and recreated.

GENERATION_COMMENTS

STRING

none

none

none

empty string

Enter additional comments for the generated code.

TARGET_TABLESPACE_NAME

STRING

none

none

none

DEFAULT

Tablespace name in the target database. Target tablespace name must be same with source tablespace name prior to Oracle 10.2.


TRANSPORTABLE_MODULE_DATAFILE Object

Table 4-67 TRANSPORTABLE_MODULE_DATAFILE Object

Property Type Choices Min Max Default Description

DIRECTORY

STRING

none

none

none

empty string

 

FILENAME

STRING

none

none

none

DEFAULT

The name of the new file on target. Please check to see if there is already a file with same name in the same directory. Transportable tablespace deployement may overwrite any existing files.

REUSE

BOOLEAN

true, false

none

none

false