Download Oracle Streams Advanced Queuing User's Guide and Reference

Managing Queue Tables
Example 8–13
Instances
Altering a Queue Table by Changing the Primary and Secondary
BEGIN
DBMS_AQADM.ALTER_QUEUE_TABLE(
queue_table
=> 'test.obj_qtab',
primary_instance
=> 3,
secondary_instance
=> 2);
END;
/
Example 8–14
Altering a Queue Table by Changing the Comment
BEGIN
DBMS_AQADM.ALTER_QUEUE_TABLE(
queue_table
=> 'test.obj_qtab',
comment
=> 'revised usage for queue table');
END;
/
Dropping a Queue Table
DBMS_AQADM.DROP_QUEUE_TABLE(
queue_table
IN
VARCHAR2,
force
IN
BOOLEAN DEFAULT FALSE,
This procedure drops an existing queue table. You must stop and drop all the queues
in a queue table before the queue table can be dropped. You must do this explicitly if
force is set to FALSE. If force is set to TRUE, then all queues in the queue table and
their associated propagation schedules are dropped automatically.
If GLOBAL_TOPIC_ENABLED = TRUE when a queue table is dropped, then a
corresponding LDAP entry is also dropped.
Example 8–15
Dropping a Queue Table
BEGIN
DBMS_AQADM.DROP_QUEUE_TABLE(
queue_table
=> 'test.obj_qtab');
END;
/
Example 8–16
Dropping a Queue Table with force Option
BEGIN
DBMS_AQADM.DROP_QUEUE_TABLE(
queue_table
=> 'test.raw_qtab',
force
=> TRUE);
END;
/
Purging a Queue Table
DBMS_AQADM.PURGE_QUEUE_TABLE(
queue_table
IN
VARCHAR2,
purge_condition
IN
VARCHAR2,
purge_options
IN
aq$_purge_options_t);
This procedure purges messages from a queue table. It has the following parameters:
Oracle Streams AQ Administrative Interface 8-9