Queue Table Nodes

This section covers the following topics:

About Queue Table Nodes

Each node under the Queue Tables node represents a Queue table in the database.

See About Oracle Streams Advanced Queueing.

How Queue Table 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 Table

Launches the Queue Table Designer to create, modify, and save queue tables. See Queue Table Designer.

Purge Messages

Removes all messages from the queue table.

This functionality is only available in Oracle Database 10.1g release 10.1 or higher.

Query Window

Launches the Query Window of Oracle Developer Tools.

Generate Create Script

Writes the queue table definition to a .sql file.

Generate Create Script to Project

Generates the queue table definition 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.

Copy

Copies the selected node.

Delete

Deletes this queue table from the database. An error ORA-24012 is thrown if there are dependent queues for this queue table. The error message asks if you want to force the delete operation. If you select YES, all dependent queues will be deleted.

Refresh

Refreshes the node.

Properties

Shows properties for the node.

See Also

About Oracle Streams Advanced Queueing | Queue Table Designer | Queue Designer