As a going concern or a one time effort?

As suggested use replication for going concern or the sql merge command (9i) if you need to simply sync up one time

steve