Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Update Trigger for Replication

Posted on 2003-10-24
4
784 Views
Last Modified: 2013-12-11
Hi,

I am a german student writing his thesis on distributed databases. The actual DB is an Oracle 9i Enterprise Edition Release 2.

I have one table, that should be maintained on all sites. It would need updating "on commit", regardless if a new record is inserted, updated or deleted. Each site should get its own trigger, so that updates/inserts/deletes are possible on every site, with immediate replication on the other sites. However, mutations on this particular table are rather seldom, that's why I chose "triggers" over "advanced replication". I am looking for a more robust, potentially asynchronous solution.

Anything could help me ;-)

Regards,
Lars
0
Comment
Question by:Lars_Biederstedt
4 Comments
 
LVL 2

Expert Comment

by:sdrozd
ID: 9651245
well, in this case you need to set up database links to the other databases and then write a trigger that will fire on insert,update,delete to do the same DML on other nodes.
Then you repeat this for all other sites. What else do you need to know?
0
 

Author Comment

by:Lars_Biederstedt
ID: 9669979
Thanks,

but I tried triggers first, but got really confused.
i discovered Oracle Streams and it seems to be a better solution.

Lars
0
 
LVL 22

Expert Comment

by:Helena Marková
ID: 10279168
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:

PAQ/Refund.

Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

Henka
EE Cleanup Volunteer
0
 

Accepted Solution

by:
amp072397 earned 0 total points
ID: 10347420
PAQed, with points refunded (180)

amp
Community Support Cleanup Moderator
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines

792 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question