| Author |
Message |
Tauqir *nix forums beginner
Joined: 21 Jul 2006
Posts: 1
|
Posted: Fri Jul 21, 2006 12:27 am Post subject:
Can a trigger insert records into another oracle server
|
|
|
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? |
|
| Back to top |
|
 |
Sergey *nix forums beginner
Joined: 31 Mar 2005
Posts: 23
|
Posted: Fri Jul 21, 2006 1:02 am Post subject:
Re: Can a trigger insert records into another oracle server
|
|
|
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:
| Quote: | 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? |
|
|
| Back to top |
|
 |
Sergey *nix forums beginner
Joined: 31 Mar 2005
Posts: 23
|
Posted: Fri Jul 21, 2006 1:03 am Post subject:
Re: Can a trigger insert records into another oracle server
|
|
|
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:
| Quote: | 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? |
|
|
| Back to top |
|
 |
Google
|
|
| Back to top |
|
 |
|