Home » Server Options » Streams & AQ » Streams capture queue (Oracle 11g, Linux)
Streams capture queue [message #403542] Sat, 16 May 2009 14:50
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
i have created streams capture queue

BEGIN
  DBMS_STREAMS_ADM.SET_UP_QUEUE(
   queue_table   => 'STRM_CAPTURE_QUEUE_TABLE',
   queue_name  => 'STRM_CAPTURE_QUEUE',
   queue_user    =>  'STRMADMIN') ;
END;
/


i understand it should create a queue table 'STRM_CAPTURE_QUEUE_TABLE . But what are the other three additional segments got created ?

SQL> select owner,segment_name,segment_type,tablespace_name
from dba_segments
where segment_name like'%STRM%';  2    3

OWNER                          SEGMENT_NAME                        SEGMENT_TYPE       TABLESPACE_NAME
------------------------------ ----------------------------------- ------------------ ------------------------------
STRMADMIN                      STRM_CAPTURE_QUEUE_TABLE            TABLE              STREAMS_TBS
STRMADMIN                      AQ$_STRM_CAPTURE_QUEUE_TABLE_S      TABLE              STREAMS_TBS
STRMADMIN                      AQ$_STRM_CAPTURE_QUEUE_TABLE_Y      INDEX              STREAMS_TBS
STRMADMIN                      AQ$_STRM_CAPTURE_QUEUE_TABLE_P      TABLE              STREAMS_TBS


Previous Topic: Schema Stream replication have Error ORA-26687: no instantiation SCN provided
Next Topic: Error in streams process.
Goto Forum:
  


Current Time: Fri Mar 29 10:37:21 CDT 2024