tags:

views:

78

answers:

2

Oracle Guru(s) I need your help. Suppose I clone an oracle database on January 1 and then make another clone of that database on January 2. Is it possible to diff the changes in meta data and data between the two clones, and then apply those changes to the January 1 Database? What tools are available? Any and all suggestions are welcome.

+1  A: 

The easy way to do this is to use Toad for Oracle. It has excellent schema and data comparison tools.

vls
A: 

Look at Embarcadero DB Change Manager which in features

Schema compare and sync

alt text

Data compare and sync

alt text

Available for oracle among other databases.

jachguate