Striim 3.9.4 / 3.9.5 documentation

Creating the quiescemarker table

To quiesce (see Console commands) an application that uses OracleReader, you must create a quiescemarker table in Oracle. The DDL for creating the table is: 

CREATE TABLE QUIESCEMARKER (source varchar2(100), 
  status varchar2(100),
  sequence NUMBER(10),
  inittime timestamp, 
  updatetime timestamp default sysdate, 
  approvedtime timestamp, 
  reason varchar2(100), 
  CONSTRAINT quiesce_marker_pk PRIMARY KEY (source, sequence));

The Oracle user specified in OracleReader's Username property must have SELECT, INSERT, and  UPDATE privileges on this table.

Note

QUIESCE is not supported with XStream Out, only with LogMiner.