Oracle® Warehouse Builder OMB*Plus Command Reference 11g Release 2 (11.2) Part Number E14406-01 |
|
|
Mobi · ePub |
Should be in the context of an Oracle Module. The Object Type can exist in any Oracle Module.
createQTCommand = OMBCREATE ( QUEUE_TABLE "QUOTED_STRING" [ SET "setQTPropertiesClause" ] ) setQTPropertiesClause = PROPERTIES "(" "propertyNameList" ")" VALUES "(" "propertyValueList" ")" propertyNameList = "UNQUOTED_STRING" { "," "UNQUOTED_STRING" } propertyValueList = "propertyValue" { "," "propertyValue" } propertyValue = ( "QUOTED_STRING" | "INTEGER_LITERAL" | "FLOATING_POINT_LITERAL" )
Sets properties (core, logical, physical, user-defined) for Queue Table. Valid properties are shown below:
Basic properties for QUEUE_TABLE: Name: BUSINESS_NAME Type: STRING(200) Valid Values: Any valid character string in supported character set. Default: Empty string Business name of the Queue Table Name: DESCRIPTION Type: STRING(4000) Valid Values: Any valid character string in supported character set. Default: Empty string Description of the Queue Table Name: PAYLOAD_TYPE Type: STRING(4000) Valid Values: Any valid character string in supported character set. Default: Empty string Object Type for the Queue Table. This has to be the name of an Object Type (OBJECT_TYPE) existing in any Oracle Module.
Property | Type | Choices | Min | Max | Default | Description |
---|---|---|---|---|---|---|
DEPLOYABLE |
BOOLEAN |
true, false |
none |
none |
true |
Warehouse Builder generates a set of scripts to create an object only for those objects marked as Deployable = true. |
GENERATE_QUEUE_TABLE |
BOOLEAN |
true, false |
none |
none |
true |
Generate code to create the queue table that will persist the messages of this Advanced Queue. |
GENERATION_COMMENTS |
STRING |
none |
none |
none |
empty string |
Enter additional comments for the generated code. |
TABLESPACE |
STRING(30) |
none |
none |
none |
empty string |