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

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.