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

   queue_table   => 'STRM_CAPTURE_QUEUE_TABLE',
   queue_name  => 'STRM_CAPTURE_QUEUE',
   queue_user    =>  'STRMADMIN') ;

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: Wed Oct 26 18:12:32 CDT 2016

Total time taken to generate the page: 0.11185 seconds