Queue Nodes

About Queue Nodes

Each node under Queues node represents an Oracle Streams AQ Queue in the database. See About Oracle Streams Advanced Queueing.

How Queue Nodes Work

To perform actions on this node, right-click the node and from the menu, choose the appropriate command. To view the node's properties, select the node and/or click Properties in the node's menu.

Menu Options

Menu Options	Description
Design Queue	Launches the Queue Designer to modify the queue. See Queue Designer.
Start Enqueuing	Issues a Start Enqueuing command on this queue.
Start Dequeuing	Issues a Start Dequeuing command on this queue.
Query Window	Launches the Query Window of Oracle Developer Tools.
Generate Create Script	Writes the queue definitions to a `.sql` file.
Generate Create Script to Project	Generates a SQL script to create all queues in this collection and writes it to the Oracle Database project you select. Generates the queue definitions to a .`sql` file and adds the `.sql` file to an open Oracle Database Project. If multiple objects in Server Explorer are selected, a master SQL script is created in the Oracle Database Project Scripts folder. This master script contains calls to individual child SQL scripts (one for each schema object) generated into the various schema object folders and this master script is ordered with dependencies taken into consideration. If there are multiple open Oracle Database projects, Visual Studio prompts you to select the project to add the script to. This operation can also be performed by dragging and dropping the Server Explorer node(s) directly onto a database project folder. See Managing Oracle Script Files for more information. Note: Oracle Database Project Version 2 projects are not supported. To add scripts to this project type, use Import Schema or Add Existing Item menu items on an Oracle Database Project Version 2 project folder, or use the Schema Compare tool.
Privileges	Launches the existing Grant/Revoke privileges dialog.
Delete	Deletes this queue from the database.
Refresh	Refreshes the node.
Properties	Shows properties for the node.