Can a trigger insert records into another oracle server

Tauqir · *nix forums beginner Joined: 21 Jul 2006 Posts: 1

A design situation requires an add/update trigger on rows of a table
should insert records in a table in another oracle server.
Can it be done, are there limitations?

Sergey · *nix forums beginner Joined: 31 Mar 2005 Posts: 23

Try to create DB link between databases (you may even create synonym
for a remote table as tablex@remote server and insert into tablex)
Tauqir wrote:

Sergey · *nix forums beginner Joined: 31 Mar 2005 Posts: 23

Try to create DB link between databases (you may even create synonym
for a remote table as tablex@remote server and insert into tablex)
Tauqir wrote:

Google