Oracle9i Application Developer's Guide - Advanced Queuing Release 1 (9.0.1) Part Number A88890-02 |
|
Administrative Interface, 5 of 36
Alter the existing properties of a queue table.
When a queue, queue table, or subscriber is created, modified, or dropped, and if GLOBAL_TOPIC_ENABLED = TRUE, a corresponding LDAP entry is also created.
See Chapter 3, "AQ Programmatic Environments" for a list of available functions in each programmatic environment. Use the following syntax references for each programmatic environment:
See Chapter 3, "AQ Programmatic Environments" for a list of available functions in each programmatic environment. Examples are provided in the following programmatic environments.
/* Altering the table to change the primary, secondary instances for queue owner (only applicable for Real Application Clusters environments).The primary instance is the instance number of the primary owner of the queue table. The secondary instance is the instance number of the secondary owner of the queue table. */ EXECUTE dbms_aqadm.alter_queue_table ( Queue_table => 'aq.ObjMsgs_qtab', Primary_instance => 3, Secondary_instance => 2); /* Altering the table to change the comment for a queue table: */ EXECUTE dbms_aqadm.alter_queue_table ( Queue_table => 'aq.ObjMsgs_qtab', Comment => 'revised usage for queue table'); /* Altering the table to change the comment for a queue table and use nonrepudiation: */ EXECUTE dbms_aqadm.alter_queue_table ( Queue_table => 'aq.ObjMsgs_qtab', Comment => 'revised usage for queue table',
/* Alter a queue table */ public static void example(AQSession aq_sess) throws AQException { AQQueueTableProperty qtable_prop; AQQueueTable q_table; q_table = aq_sess.getQueueTable ("aq", "ObjMsgs_qtab"); /* Get queue table properties: */ qtable_prop = q_table.getProperty(); /* Alter the queue table comment and instance affinity */ q_table.alter("altered queue table", 3, 2); }
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|