ORA-26840: Combined capture and apply optimization is disabled because Streams is unable to identify
edited Jul 25, 2013 4:59AM in GoldenGate, Streams and Distributed Database (MOSC) 6 commentsAnswered
I am trying to configure simple streams replication (I am totally new to streams)and have used the steps exactly described in the document
http://apunhiran.blogspot.com/2009/07/how-to-setup-up-of-oracle-streams.html
Unfortunately if I insert data into dept table,its not replicating to other db.I have run the following queries and results are as below from source db
SQL> select apply_name,state,DEQUEUE_TIME from V$STREAMS_APPLY_READER;
APPLY_NAME STATE DEQUEUE_T
------------------------------ ------------------------------------ ---------
APPLY_STREAM IDLE
SQL> select CAPTURE_NAME, STATE from v$streams_capture;
CAPTURE_NAME
------------------------------
STATE
--------------------------------------------------------------------------------
CAPTURE_STREAM
WAITING FOR TRANSACTION
http://apunhiran.blogspot.com/2009/07/how-to-setup-up-of-oracle-streams.html
Unfortunately if I insert data into dept table,its not replicating to other db.I have run the following queries and results are as below from source db
SQL> select apply_name,state,DEQUEUE_TIME from V$STREAMS_APPLY_READER;
APPLY_NAME STATE DEQUEUE_T
------------------------------ ------------------------------------ ---------
APPLY_STREAM IDLE
SQL> select CAPTURE_NAME, STATE from v$streams_capture;
CAPTURE_NAME
------------------------------
STATE
--------------------------------------------------------------------------------
CAPTURE_STREAM
WAITING FOR TRANSACTION
0