Skip to main content
Database Administrators

Return to Question

Added tag created recently. Attached the tag of the DBMS version mentioned in the post. Removed "EDIT" (see https://meta.stackexchange.com/a/127655 ). Rewordings. Etc.
Source Link
MDCCL
MDCCL
  • 8.5k
  • 3
  • 31
  • 62

I got a question about 2two databases (oraclein 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.

EDITAdditional information:

Thanks for the answers, I don't know if it's relevant, but I found function "minus" butthe MINUS operator, though I'm not sure if it works with a "sub table"  (select).

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.

EDIT:

Thanks for the answers, I don't know if it's relevant, but I found function "minus" but I'm not sure if it works with a "sub table"(select)

I got a question about two databases (in 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.

Additional information:

Thanks for the answers, I don't know if it's relevant, but I found the MINUS operator, though I'm not sure if it works with a "sub table"  (select).

Bounty Ended with no winning answer by CommunityBot
Tweeted twitter.com/#!/StackDBAs/status/77019273763110912
Bounty Started worth 50 reputation by Marco Aviles
information added
Source Link
Marco Aviles
Marco Aviles
  • 115
  • 7

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.

EDIT:

Thanks for the answers, I don't know if it's relevant, but I found function "minus" but I'm not sure if it works with a "sub table"(select)

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.

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.

EDIT:

Thanks for the answers, I don't know if it's relevant, but I found function "minus" but I'm not sure if it works with a "sub table"(select)

Source Link
Marco Aviles
Marco Aviles
  • 115
  • 7

Database replication and consistency check

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.