I have one server at my office and another at branch. I have dataline connection. Both the Oracle servers are having same database structure. I want to write trigger on on table that if new row inserted in that table I want to transer that entry to my office server. Plz help me.
2006-12-12 23:59:10 · 5 answers · asked by dipak 2 in Computers & Internet ➔ Programming & Design
You need to use an Oracle database link in combination with a trigger, it's pretty straightforward once you get your head around it.
First, set up your tnsnames.ora on the source server so you can do a tnsping to the destination, i.e. run
tnsping targetdatabase
and get a positive response
Then, to create the link, as the sys user on your source database, run:
create public database link
Then write your trigger as normal, adding an @targetdatabase at the end of your insert statement, for example:
This query acts on your local database
SELECT name FROM scott.emp;
This query acts on your remote database
SELECT name FROM scott.emp@targetdatabase;
2006-12-13 04:34:53 · answer #1 · answered by Ewan 2 · 0⤊ 0⤋
before each and every thing oracle can run on abode windows. i do not comprehend if CITRIX received't help you run an Oracle Database. There are some seen problem-free linux implementations, yet I recommend you study a actual programming language. Oracle has shopper software that permits you to attach to the database. You in reality run the oracle server on the Unix device and connect to it on the abode windows device. CITRIX looks to easily be a miles off login by an internet site. sounds like distant login for newbs to me. Linux and Unix have supported this for years. you should use telnet, ssh to login to the terminal. you are able to also run an XServer and set the exhibit variable and get a GUI. I attempt this each and each and every of the time with CYGWIN which has XServer, so i do not comprehend what the purpose of creating use of CITRIX somewhat is.
2016-11-26 00:36:38 · answer #2 · answered by oroza 4 · 0⤊ 0⤋
Maybe a Ethernet cable
2006-12-13 00:06:52 · answer #3 · answered by wcnghj 3 · 0⤊ 0⤋
Joe Willy Neckbone says, " I don't rightly know the answer to this question, but I will be right here when you ask a question that I do know the answer to."
2006-12-13 00:06:27 · answer #4 · answered by joewillyneckbone 2 · 0⤊ 0⤋
http://www.orafaq.com/forum/t/67544/0/
2006-12-13 00:03:53 · answer #5 · answered by bsmith13421 6 · 0⤊ 0⤋