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

OMBALTER TRANSPORTABLE_MODULE

Purpose

Prerequisites

Syntax

Parameters

alterTMCommand

QUOTED_STRING

alterTMClause

renameClause

QUOTED_STRING

setPropertiesAndLocationsAndIconSet

unsetReferenceIconSetClause

modifyClause

setPropertiesClause

setPropertiesClause

setSourceLocationClause

QUOTED_STRING

setTargetLocationClause

QUOTED_STRING

setReferenceIconSetClause

QUOTED_STRING

modifyTablespaceClause

QUOTED_STRING

modifyDatafileClause

QUOTED_STRING

modifySchemaClause

QUOTED_STRING

propertyNameList

propertyValueList

propertyValue

TRANSPORTABLE_MODULE Object

TRANSPORTABLE_MODULE_TABLESPACE Object

TRANSPORTABLE_MODULE_DATAFILE Object

See Also