Oracle Database Discussions

hi all,

i have an issue and the scenario as follows


we have Core banking solution with three database.

database names as follows >> a , b , c

now in database (a) we have a table which updates another table on ( b) database through a dblink which causes our EOD process to be delayed as it has to update around 800000 record during the process and causes alot of dblink network wait time , although the three database resides on the same BOX,


my question is ?

what is the best practice of updating one table to (b) database from (a) database other than enabling the trigger


sharing your knowledge with me appreciated

thanks and regards

Samer ALJazzar