I'd create a stored proc that does the update bits and bobs you require, and I agree with above, the best way is to use a database link.
You can fire this procedure at set intervals using an oracle timed job.