| Oracle® Warehouse Builder OMB*Plus Command Reference 11g Release 2 (11.2) Part Number E14406-01  | 
  | 
  | 
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  |