| Copy history from db1 to db 2 [message #444198] |
Fri, 19 February 2010 05:08  |
elnbado
Messages: 1
Registered: February 2010
|
Junior Member |
|
|
Hi,
We have two databases; one production and one history.
We have several jobs that copy data from the production to the history. We use two different ways:
1.
From the production database we copy the data to the history using a db link (push strategy).
This is mostly done when a record is inserted.
2.
From the history database we copy the data from the production using a db link (pull strategy).
This is mostly done using a dbms jobs which runs (eg.)every week.
I think the second option is more effecient since the use of the database links are kept to a minimum. I also believe that in option 2 the history database does most of the work so that the production database is loaded less heavily.
However, I can't find anything to confirm my believes.
Is my believe that option 2 is more efficient true?
Thanks in advance for any answer in this matter.
Regards,
Barry
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
