You can write your own scripts to do this fairly easily. Oracle puts a lot of metadata into views to allow just this sort of thing. all_tab_columns, user_tab_columns, user_sequences, user_indexes etc. Here's a page with a complete listing: http://www.lc.leidenuniv.nl/awcourse/oracle/server.920/a96536/index.htm
-----Original Message----- From: Michael Nhan [mailto:[EMAIL PROTECTED] Sent: Thursday, June 16, 2005 11:15 AM To: Steve Sapovits Cc: [email protected] Subject: Re: Oracle schema comparison Hi, Look into Toad by quest software. It has a schema comparison tool. Regards, Michael > Date: Thu, 16 Jun 2005 11:11:12 -0400 > From: Steve Sapovits <[EMAIL PROTECTED]> > To: [email protected] > Subject: Oracle schema comparison > > > Does anybody know of any good tools (free or otherwise) for comparing > two Oracle schemas? I'd want to be able to compare tables, indices, > sequences, etc. to see what one has and another doesn't. In an ideal > world I'd also be able to compare the actual data in the tables, but > the primary need is to be able to see if tables and indices match. > > ---//--- "He who learns must suffer. And even in our sleep, pain that cannot forget, falls drop by drop upon the heart; and, in our own despair, against our will, comes wisdom to us by the awful grace of God." --- Aeschylus
