Is there any pro and cons of creating Database links?
I am Planning to create a database link for a job having two different database to use full pushdown approach.
Now my concern is what would be its effect if same target datastore is used in other jobs as well ?
On basis of this I think of two scenarios where,
1> My Source and target database is A and B.
2> Now my Source database has changed but target database is same. e.g C and B.