Re: comparing Oracle databases

In previous article, Ayrton Sargusingh SBR/SST/DREO (asargusi_at_sbrsim.ed.dreo.dnd.ca) wrote:
[QUOTE]Hi everyone:

[QUOTE]I have a particular problem with project I'm working on. A
[QUOTE]contractor of ours has modified a copy of a rather large
[QUOTE]database. Does anyone know if or how I could compare both
[QUOTE]the old and the new databases? Performing oracle dumps of
[QUOTE]both databases does not appear to help; since dump files are
[QUOTE]not plain ASCII text files, they cannot be diff'ed.

    First of all, compare the tables by querying some views from the data dictionary. Next, compare the table structures. Later, the data in the table. I expect dblink will be heavily used.

--

                                                               Best Regards,

                                                                 Lun Wing San
                                                                 ­Û  ¥Ã   ·s


Email address : sunny_at_hkpc.org 
Telephone     : (852)2758 5936 / (852)2788 5841