Referential Integrity - Replication

Hi all,
If I am using async replication of several tables with RI relationship, is there a chance that the RI can not be maintained during replication failed, if so, how can I resolve this problem, appreciate for your help.
Matthew 

Hello Matthew,
if you use snapshot groups at the snapshot site, all objects within are replicated as one transaction.
regards
Matthias 

Matthew,
I had RI constraint problem with Snapshot replication and I dropped all RI constraints and created initially deferred and that works great.
Pravin

Related

Bi-directional Replication using Streams.

I have setup Bi-directional Replication using Streams.
But some tables are out of sync is there any way ,we can bring them in sync without stopping the capture and porpagation process.
Thanks in advance
Regards
Micky 
But some tables are out of sync is there any way ,we Confirm me; Those object depent to any other project.?? If Yes NOT Possible 
Yes,Replication is just one project but these objects are used by many other applications.
Thanks for your prompt reply
Regards
Micky 
Hello-
I have one question.
Daily, we are getting few errors in dba_apply_error and tables goes out of sync. Is there is way that we can fix permanently.
We added supplemental logging ,set ket key and conflict handler as well..
Did we miss something? Our setup is bidirectional replication setup...
Please advice.
Any help would be appreciate.
Thanks,
Nick

OWB11r2 data chunking: cannot find package DBMS_APPLY

Hi,
I'm trying the new data chunking feature of owb11r2. I got it running with serial strategy. But when I switch to parallel strategy, the mapping does not compile. It tries to call the package DBMS_APPLY, but that cannot be found:
DBMS_APPLY.INITIALIZE(..);
DBMS_APPLY.CHUNK_TABLE_BY_ROWID(..);
Target db is 11r2.
Any idea?
Regards,
Carsten. 
Hi Carsten
There is a bug (9057172) logged for this. I have tried to workaround but couldn't find any mechanism.
Cheers
David 
Hi David,
thanks for the quick answer,
Carsten.

Data Missing

I have a seven record into table but when I sync using IPAQ it sync successfully.
But I got only six records not seven from that table. So anyone can tell me why is that?
I will appreciate your reply.
Thanks
Him 
Hi,
I have a similar problem. I have 7 tables and when i sync only one table data got to the client.
Is there any way i can control the sync using 9i lite.
Appreciate your response.
Regards,
Ravi Chand

Statement-Triggers

Hi
We have some Triggers we realy need. Is it possible to move this triggers to _LT-Tables ?
Kind Regeards
Toni 
Toni
We recommmend that you do not apply the triggers to the base _LT table. Can you explain what you are trying to do, maybe we can work an alternate solution for you.
thanks
Arun Gopalan
Workspace Manager Development
Oracle Corp.
gopalan.arun#oracle.com 
We use spatial and there are some triggers to update topology-information - during insert/modify this functions have to read same table and also object to be inserted/modified.
Also we think there are other problems:
- How to implement undo/redo
shall we really create savepoint after each operation ?- import of data in non-empty dump
- 3rd party applications that connect via its own connection we cannot impact - this connection may be is also read-only
how to set the correct workspace Thank you for help
Toni
Toni
Mail me your phone number. It may be easier to resolve this over the phone..
regards
Arun
gopalan.arun#oracle.com

Update primary key in replication environment.

Hello all,
I would appreciate, if you could answer for my question.
I am using oracle9i advanced asynchronous replication. What would be the issue if we update the primary key. Is it going to create any problem ?. What is the drawback on updating Primary key.
Thanks
Govind

Categories

Resources