How about restores from backups? No need for comparisons afterward, no worries about LONGs or types of partitioning, etc... on 7/9/04 11:16 AM, ryan.gaffuri@xxxxxxxxxxx at ryan.gaffuri@xxxxxxxxxxx wrote: > I just started a new project. We have 56 databases. This is between dev,test, > and prod. This is not a distributed system so its just one application. > Apparently many of them are not in synch. > We are doing 4 releases at the same time. Release 4 will include changes that > release 1 has however, all of these releases are in development at the same > time. There is no repository or ERD. > We need to find the best way to synch up the databases. Here are some methods. > What have you done? > 1. OEM -- apparently this works, but it takes about 90 minutes to compare two > databases > 2. Toad -- fast, but inaccurate. It fails on some views and packages. > 3. Code -- We are considering doing a data extract to the file system and then > using a script to diff everything. > We have talked about using Designer, the problem is that this application is > rather large and is already partially deployed. So to backward engineer it > into designer would take a significant amount of time. Plus we are using hash > partitioning which is not supported by designer, so we would need to do > post-generation changes. > Anyone have any experiences to share on how they managed this? ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------