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