Purpose
To retrieve properties of a transportable module, its contents and their properties, and source and target locations.
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.
