How do I narrow my search results?
After you submit your search query:
- On the Refine Search results page, select one or more categories of products or services from the left sidebar.
- Then for a category with search results, click Select to choose your product and release filters, and then click OK.
For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"
How do I find the documentation for my product or service?
From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:
- Click the Find a product tab and search for your product or service.
- Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
- Apple Safari: Version 6
- Google Chrome: Version 29 and later
- Mozilla Firefox: Version 24 and later
- Microsoft Internet Explorer: Version 9 and later
Queue Table Subprograms → Table 23-2 Queue Table Subprograms Subprograms Description ALTER_QUEUE_TABLE Procedure Alters the … existing properties of a queue table CREATE_QUEUE_TABLE Procedure Creates a queue table for messages … of a predefined type DROP_QUEUE_TABLE Procedure Drops an existing
Queue Table Export-Import → When a queue table is exported, the queue table data and anonymous blocks of PL/SQL code are … written to the export dump file. When a queue table is imported, the import utility executes these PL/SQL … buffered messages. If there exists a queue table
Creating a Queue Table → IN VARCHAR2 DEFAULT NULL, secure IN BOOLEAN DEFAULT FALSE); This procedure creates a queue table … Description queue_table This required parameter specifies the queue table name. Mixed case (upper and … lower case together) queue table names are supported if database compatibility is
Dropping a Queue Table → 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
Creating a Queue Table → , oracle.AQ.AQQueueTableProperty property) throws JMSException This method creates a queue table. It has … the following parameters: Parameter Description owner Queue table owner ( schema ) name Queue table … name property Queue table properties If the
Purging a Queue Table → IN aq$_purge_options_t); This procedure purges messages from a queue table. It has the following … parameters: Parameter Description queue_table This required parameter specifies the queue table name … messages are also supported for buffered messages. To purge all queues in a queue table,
Exporting Queue Table Data → tables. Export of queues can also be accomplished at queue-table granularity. Exporting Queue Tables with … Multiple Recipients A queue table that supports multiple recipients is associated with the … queue table, the import process generates a note about the ROWIDs
Creating Queue Table Definitions → Queues are stored in queue tables. Each queue table is a database table and contains one or more … queues. Creating a queue table creates a database table with approximately 25 columns. These columns … table. To create queue tables:
Importing Queue Table Data → related dictionary data. After the queue table data is imported, the import utility executes the PL/SQL … Tables with Multiple Recipients A queue table that supports multiple recipients is associated with the … must be imported as well as the queue table itself. Import IGNORE Parameter
Getting a Queue Table → JMSException This method gets a queue table. It has the following parameters: Parameter Description … owner Queue table owner ( schema ) name Queue table name If the caller that opened the connection is … not the owner of the queue table, then the caller
Altering a Queue Table → procedure alters the existing properties of a queue table. Parameter Description queue_table This … required parameter specifies the queue table name. comment This optional parameter is a user-specified … description of the queue table. This user comment is added to the queue
Migrating a Queue Table → migrates a queue table from 8.0, 8.1, or 10.0 to 8.0, 8.1, or 10.0. Only the owner of the queue table … to the queue table owner, who is probably an ordinary queue user. If you do not want ordinary queue … created in a queue table
ALTER TABLE → -organized, temporary, or part of a cluster. It also cannot be a queue table, an object table, or the … Purpose Use the ALTER TABLE statement to alter the definition of a nonpartitioned table, a … partitioned table, a table partition, or a table subpartition.
Queue Table Level Export and Import → Export import of queues is now fully supported at queue table level granularity. The user only … needs to export the queue table. All the queues in the queue table, primary object grants, related
JMS-179 Invalid Queue Table name - (string) → value of the owner parameter JMS-179 Invalid Queue Table name - (string) … Cause: The queue name specified is or invalid Action: Specify a queue name that is not … . The queue name must not be qualified with the schema name. The schema name must be specified as the
AQ$Queue_Table_Name: Messages in Queue Table → The AQ$ Queue_Table_Name view describes the queue table in which message data is stored. This view … is automatically created with each queue table and should be used for querying the queue data. The … single-consumer queues. In a queue table that is created with the
JMS-173 Queue Table (string) not found → Cause: More than one queue table matches the query Action: Specify both owner and queue table name JMS-173 Queue Table (string) not found
JMS-187 Queue Table must be specified → Cause: QueueTableProperty specified is Action: Specify a non- AQQueueTableProperty JMS-187 Queue Table must be specified
Creating Indexes on a Queue Table → Creating an index on a queue table is useful if you: Dequeue using correlation ID An index created … on the column corr_id of the underlying queue table AQ$_ QueueTableName expedites dequeues. Dequeue … underlying queue table. An index on QueueTableName expedites performance on this
Queue Subprograms → Table 23-4 Queue Subprograms Subprograms Description ALTER_QUEUE Procedure Alters existing … Creates a queue in the specified queue table DROP_QUEUE Procedure Drops an existing queue … properties of a queue CREATE_NP_QUEUE Procedure Creates a nonpersistent RAW queue