2.3.5 ALTER QUEUE TABLE

Table of Contents Previous Next


2 The SQL Language : 2.3 SQL Commands : 2.3.5 ALTER QUEUE TABLE

Advanced Server includes extra syntax (not offered by Oracle) with the ALTER QUEUE SQL command. This syntax can be used in association with the DBMS_AQADM package.
ALTER QUEUE TABLE-- modify an existing queue table.
Use ALTER QUEUE TABLE to change the name of an existing queue table:
ALTER QUEUE TABLE name RENAME TO new_name
ALTER QUEUE TABLE allows a superuser or a user with the aq_administrator_role privilege to change the name of an existing queue table.
The name (optionally schema-qualified) of an existing queue table.
To change the name of a queue table from wo_table_east to work_order_table:

2 The SQL Language : 2.3 SQL Commands : 2.3.5 ALTER QUEUE TABLE

Table of Contents Previous Next