Creating Queues and Queue tables
Steams data flow is totally integrated with
the queues. Both the source database and destination database
need to have queues to manage events. Events are stored or
staged in a queue. These events may be captured events or user-enqueued
events. The Capture process enqueues events into a SYS.AnyData
queue. A SYS.AnyData queue can stage events of different types.
The queue and its associated queue table can be created by using
the procedure set_up_queue of the dbms_streams_adm
package.
Figure 4.3 Procedure for creating
the queue
As shown in Figure 4.3, the queue name and
queue table name must be supplied as arguments. In order to
specify the storage characteristic features such as the
tablespace, the storage_clause argument can be used.
The following SQL statement can be used to
view the queues:
set linesize 132
COLUMN OWNER HEADING
'Owner' FORMAT A14
COLUMN NAME HEADING
'Queue Name' FORMAT A30
COLUMN QUEUE_TABLE HEADING
'Queue Table' FORMAT A25
COLUMN USER_COMMENT HEADING
'Comment' FORMAT A25
