The tag has no usage guidance.

learn more… | top users | synonyms

0
votes
1answer
253 views

Keeping messages in a backup table after dequeue is completed

I would like to transfer the enqueued messages to a backup table after they have been dequeued. Currently we are using DBMS_AQ.DEQUEUE with mode dequeue_mode := DBMS_AQ.REMOVE. So after the message ...
9
votes
0answers
239 views

9i streams capture doesn't evaluate rules

I have a streams replication set up between two oracle 9.2.0.8 instances as sources and an 11g instance as a destination, processing a small subset of data from each database (let it be one table ...
2
votes
0answers
592 views

oracle streams apply: how to get a reason why LCR message was not applied

I've set up bidirectional oracle streams replication (11gR1) using identical scripts on both machines (DB1 and DB2). Although changes from DB1 are being applied to DB2, changes from DB2 to DB1 aren't. ...
1
vote
0answers
186 views

How can you re-synchronize oracle streams automatically?

I have noticed that when a process of oracle streams (e.g. capture/apply/propagate) is stopped or disabled, and at the same time, changes are made to the source and/or destination table/database/...
0
votes
0answers
43 views

How to delete alogs fom Oracle downstream target

I try to automate deleting logs from Oracle Downstream target database, which are not needed for capture process anymore. The query: SELECT NAME , PURGEABLE from DBA_REGISTERED_ARCHIVED_LOG; ...