I got a question about 2 databases (oracle 10g) that I have, let's call them A and B. A have some information(in various tables) and I want B to get a partial copy of some tables from A, and constantly check changes in A and 'sync' them in B.
I want to ask you about some method, technique or maybe ideas, knowing that I can't make any change in A(just selects, no triggers).
I thank you help and patience(for possible edits) in advance.