Skip Headers
Oracle® Warehouse Builder OMB*Plus Command Reference
11g Release 2 (11.2)

Part Number 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

OMBALTER QUEUE_TABLE

Purpose

Alter the Queue Table by resetting its properties.

Prerequisites

Should be in the context of an Oracle Module. The target Queue should exist in any Oracle Module.

Syntax

alterQTCommand =  OMBALTER ( QUEUE_TABLE "QUOTED_STRING" ( "renameClause" [
           SET "setQTPropertiesClause" ] | SET "setQTPropertiesClause" ) )
     renameClause =  RENAME TO "QUOTED_STRING"
     setQTPropertiesClause =  PROPERTIES "(" "propertyNameList" ")" VALUES "(" 
          "propertyValueList" ")"
     propertyNameList =  "UNQUOTED_STRING" { "," "UNQUOTED_STRING" }
     propertyValueList =  "propertyValue" { "," "propertyValue" }
     propertyValue =  ( "QUOTED_STRING" | "INTEGER_LITERAL" | 
          "FLOATING_POINT_LITERAL" )

Parameters

alterQTCommand

Alters the Queue Table with the given name by either renaming it or by setting it's properties or both.

renameClause

Renames the Queue Table to the given name.

setQTPropertiesClause

Sets properties (core, logical, physical, user-defined) for Queue Table. Valid properties are shown below:

getQTPropertiesClause

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.

propertyNameList

The list of properties.

propertyValueList

The list of property values.

propertyValue

This clause adds the property values.

QUEUE_TABLE Object

Table 4-7 QUEUE_TABLE Object

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