RE: Comparing different instances for schema differences

2001-06-22 Thread laura hardy
Tom, Thank you very much for the script and the toad suggestion. I really appreciate your time, both the script and Toad will come in handy. Laura. --- "Mercadante, Thomas F" <[EMAIL PROTECTED]> wrote: > Laura, > > Attached is a script that does the job reasonably > well. > > But I would su

RE: Comparing different instances for schema differences

2001-06-22 Thread Mercadante, Thomas F
Laura, Attached is a script that does the job reasonably well. But I would suggest that you go to www.toadsoft.com and download their latest free version of Toad. It has a very good schema compare function that will provide you with a list of differences. You will need a database link to conne

Re: Comparing different instances for schema differences

2001-06-21 Thread Rachel Carmichael
Laura, New to Oracle, but not databases. (Laura and I worked together years back). There are products out on the market that will do this, Quest Software's Schema Manager comes to mind. What exactly are you looking for when you say differences? Columns? Column sizes? Ordering of the columns i