Originally posted by stecal
UNIX? What an excellent learning opportunity you have to learn a bit of shell scripting. Look at UNIX Made Easy. You can look online for Livefire Labs. Learn how to fish.
Another oppurtunity to learn the oracle itself...
Go ahead setup the dblink between the two, create a job on the second instance to periodically (whenever you need ) to truncate the tables and pull the data from the first db and populate...

You can bill more though!!