The tag has no usage guidance.

learn more… | top users | synonyms

0
votes
0answers
25 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; ...
1
vote
0answers
123 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 ...
1
vote
1answer
202 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 ...
1
vote
1answer
205 views

Which version of Oracle supports Streams

I am using Oracle 10g Express Edition. I want to enable the streams feature in my current edition. However, when I searched on the net I couldn't find any information regarding streams setup on Oracle ...
2
votes
0answers
539 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. ...
8
votes
0answers
213 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
1answer
1k views

oracle streams - how to get last successfully applied scn for crashed apply?

I have a downstream Streams replication set up between Oracle 9i (source) and Oracle 11g (destination). The process is still in developlment stage, so the whole setup is not stable yet. Sometimes my ...
2
votes
1answer
72 views

Transaction stays in capture queue

I set up simple bidirectional db replication using Oracle Streams. I used enterprise manager for this. Streams are active and their status is ok. The problem is that the replication is very slow. What ...
1
vote
1answer
541 views

Oracle Streams Setup Error

I am running Oracle 11g on a Linux box. I am trying to run the following command to set my streams user grants and other authorizations: BEGIN DBMS_STREAMS_AUTH.GRANT_ADMIN_PRIVILEGE( grantee ...