ALTER_QUEUE_TABLE v13

Suggest edits

Use the ALTER_QUEUE_TABLE procedure to modify an existing queue table. The signature is:

ALTER_QUEUE_TABLE (
  <queue_table> IN VARCHAR2,
  <comment> IN VARCHAR2 DEFAULT NULL,
  <primary_instance> IN BINARY_INTEGER DEFAULT 0,
  <secondary_instance> IN BINARY_INTEGER DEFAULT 0,

Parameters

queue_table

The (optionally schema-qualified) name of the queue table.

comment

Use the comment parameter to provide a comment about the queue table.

primary_instance

primary_instance is accepted for compatibility and stored, but is ignored.

secondary_instance

secondary_instance is accepted for compatibility, but is ignored.

Example

The following command modifies a queue table named work_order_table:

EXEC DBMS_AQADM.ALTER_QUEUE_TABLE
      (queue_table => 'work_order_table', comment => 'This queue table
contains work orders for the shipping department.');

The queue table is named work_order_table; the command adds a comment to the definition of the queue table.

← Prev

ALTER_QUEUE

Next →

CREATE_QUEUE