OMBRETRIEVE TRANSPORTABLE_MODULE

Purpose

To retrieve properties of a transportable module, its contents and their properties, and source and target locations.

Prerequisites

In the context of a project.

Syntax

retrieveTMCommand =  OMBRETRIEVE TRANSPORTABLE_MODULE "QUOTED_STRING" GET (
           "getPropertiesClause" | "getTablespacePropertiesClause" | 
          "getDatafilePropertiesClause" | "getSchemaPropertiesClause" | 
          "getTablespacesClause" | "getDatafilesInTablespaceClause" | 
          "getSchemasInTablespaceClause" | "getAllSchemasClause" | 
          "getSourceLocationClause" | "getTargetLocationClause" | 
          "getReferenceIconSetClause" )
     getPropertiesClause =  PROPERTIES "(" "propertyNameList" ")"
     getTablespacePropertiesClause =  TRANSPORTABLE_MODULE_TABLESPACE 
          "QUOTED_STRING" PROPERTIES "(" "propertyNameList" ")"
     getDatafilePropertiesClause =  DATAFILE "QUOTED_STRING" PROPERTIES "(" 
          "propertyNameList" ")"
     getSchemaPropertiesClause =  TRANSPORTABLE_MODULE_SCHEMA "QUOTED_STRING" 
          PROPERTIES "(" "propertyNameList" ")"
     getTablespacesClause =  TRANSPORTABLE_MODULE_TABLESPACES
     getDatafilesInTablespaceClause =  DATAFILES IN 
          TRANSPORTABLE_MODULE_TABLESPACE "QUOTED_STRING"
     getSchemasInTablespaceClause =  TRANSPORTABLE_MODULE_SCHEMAS IN 
          TRANSPORTABLE_MODULE_TABLESPACE "QUOTED_STRING"
     getAllSchemasClause =  ALL TRANSPORTABLE_MODULE_SCHEMAS
     getSourceLocationClause =  SOURCE_LOCATION
     getTargetLocationClause =  TARGET_LOCATION
     getReferenceIconSetClause =  ( REF | REFERENCE ) ICONSET
     propertyNameList =  "UNQUOTED_STRING" { "," "UNQUOTED_STRING" }

Parameters

retrieveTMCommand

This command is for querying information about the transportable module and its contents.

getPropertiesClause

Retrieve properties for the transportable module.

getTablespacePropertiesClause

Retrieve properties for a tablespace within the transportable module.

QUOTED_STRING

The name of the tablespace whose properties are to be retrieved.

getDatafilePropertiesClause

Retrieve properties for a datafile within the transportable module.

QUOTED_STRING

The name of the datafile whose properties are to be retrieved.

getSchemaPropertiesClause

Retrieve properties for a schema within the transportable module.

QUOTED_STRING

The name of the schema whose properties are to be retrieved.

getTablespacesClause

Retrieve names of all tablespaces in the transportable module.

getDatafilesInTablespaceClause

Retrieve names of all datafiles of a tablespace within the transportable module.

QUOTED_STRING

The name of the tablespace whose datafile names are to be retrieved.

getSchemasInTablespaceClause

Retrieve names of schemas that are parts of the named tablespace.

QUOTED_STRING

The name of the tablespace whose component schemas names are to be retrieved.

getAllSchemasClause

Retrieve names of all schemas within the transportable module.

getSourceLocationClause

Retrieve name of the source ___location.

getTargetLocationClause

Retrieve name of the target ___location.

getReferenceIconSetClause

Retrieve name of the icon set.

propertyNameList

The list of unquoted property names.

See Also

OMBRETRIEVE

OMBCREATE TRANSPORTABLE_MODULE

OMBALTER TRANSPORTABLE_MODULE