Oracle® Warehouse Builder OMB*Plus Command Reference 11g Release 2 (11.2) E14406-01 |
|
|
Mobi · ePub |
Alter the control center by renaming it, and/or reseting its properties, and/or adding/removing a referenced location, and/or resetting properties of a referenced location.
alterControlCenterCommand = OMBALTER ( CONTROL_CENTER "QUOTED_STRING" ( "renameClause" [ SET "setPropertiesClause" [ "alterIconSetClause" ] { "alterReferenceLocationClause" } ] | SET "setPropertiesClause" [ "alterIconSetClause" ] { "alterReferenceLocationClause" } | "alterIconSetClause" { "alterReferenceLocationClause" } | { "alterReferenceLocationClause" } ) ) renameClause = RENAME TO "QUOTED_STRING" setPropertiesClause = PROPERTIES "(" "propertyNameList" ")" VALUES "(" "propertyValueList" ")" alterIconSetClause = SET "setReferenceIconSetClause" [ UNSET "unsetReferenceIconSetClause" ] | UNSET "unsetReferenceIconSetClause" [ SET "setReferenceIconSetClause" ] alterReferenceLocationClause = "addReferenceLocationClause" | "modifyReferenceLocationClause" | "deleteReferenceLocationClause" propertyNameList = "UNQUOTED_STRING" { "," "UNQUOTED_STRING" } propertyValueList = "propertyValue" { "," "propertyValue" } setReferenceIconSetClause = ( REFERENCE | REF ) ICONSET "QUOTED_STRING" unsetReferenceIconSetClause = ( REFERENCE | REF ) ICONSET addReferenceLocationClause = ADD ( REF | REFERENCE ) LOCATION "QUOTED_STRING" [ SET "setPropertiesClause" ] modifyReferenceLocationClause = MODIFY ( REF | REFERENCE ) LOCATION "QUOTED_STRING" SET "setPropertiesClause" deleteReferenceLocationClause = DELETE ( REF | REFERENCE ) LOCATION "QUOTED_STRING" propertyValue = ( "QUOTED_STRING" | "INTEGER_LITERAL" | "FLOATING_POINT_LITERAL" )
Properties for CONTROL_CENTER: Name: HOST Type: STRING Valid Values: Any valid character string in supported character set. Default: N/A The host machine the control center is installed on. Name: PORT Type: NUMBER Valid Values: 1 - 65535 Default: 1521 The port number of the database in which the control center is installed. Name: SERVICE_NAME Type: STRING Valid Values: Any valid character string in supported character set. Default: N/A The service name of the database in which the control center is installed. Name: USER Synonym: USER_NAME Type: STRING Valid Values: Any valid character string in supported character set. Default: N/A The name of the database user you wish to connect to the control center as. Name: PASSWORD Type: STRING Valid Values: Any valid character string in supported character set. Default: N/A The password. Name: WORKSPACE Type: STRING Valid Values: Any valid character string in supported character set. Default: N/A The name of the workspace to which to connect. All of the preceding properties (except of PASSWORD) are mandatory for OMBCREATE CONTROL_CENTER. Basic properties for CONTROL_CENTER: Name: BUSINESS_NAME Type: STRING(200) Valid Values: Any valid character string in supported character set. Default: Empty string Business name of the control center. Name: DESCRIPTION Type: STRING(4000) Valid Values: Any valid character string in supported character set. Default: Empty string Description of the control center. Properties for a referenced location of the control center: Name: IS_SOURCE Type: BOOLEAN Valid Values: true, false Default: true If true, then a referenced location is a source location. Name: IS_TARGET Type: BOOLEAN Valid Values: true, false Default: true If true, then a referenced location is a target location. Name: CONNECTION_TYPE Type: STRING Valid Values: 'HOST_PORT_SERVICE', 'SQL_NET_CONNECTION' Default: 'HOST_PORT_SERVICE' The control center connection details format.
Add a referenced location to the control center and/or set its properties.
Table 1-11 CONTROL_CENTER Object
Property | Type | Choices | Min | Max | Default | Description |
---|---|---|---|---|---|---|
CONNECTION_TYPE |
STRING |
HOST:PORT:SERVICE, SQL*NET Connection |
none |
none |
HOST:PORT:SERVICE |
Type of J2EE connection to use |
DISPLAY_TYPE |
STRING |
none |
none |
none |
CMPLocation_RuntimeRepository |
Type of the location |
HOST |
STRING |
none |
none |
none |
empty string |
Host of the location |
NET_SERVICE_NAME |
STRING(2000) |
none |
none |
none |
empty string |
Net Service Name of the location |
PASSWORD |
STRING(30) |
none |
none |
none |
empty string |
|
PLATFORM_NAME |
STRING |
none |
none |
none |
empty string |
Platform for the location. |
PORT |
NUMBER |
none |
none |
none |
1521 |
|
SCHEMA |
STRING |
none |
none |
none |
empty string |
Workspace owner.name to use for deployment |
SERVICE_NAME |
STRING |
none |
none |
none |
empty string |
Service name of the web service activity |
USER |
STRING |
none |
none |
none |
empty string |
|
VERSION |
STRING |
none |
none |
none |
0 |
Version of the location |