Re: tables diff by schema

From: Tom Zamani <tomz_at_redflex.com.au>
Date: 2000/04/04
Message-ID: <8cbbtd$454$1@perki.connect.com.au>#1/1

I have got an script which is a bit more involved. for each table create a file and by using "diff" get the differences if any. I am runing this module on unix, and it requires external procedure call. you could use utl_file package to produce the files and manualy do the diff. Tom

<norbertpk_at_my-deja.com> wrote in message news:8cbah3$7eg$1_at_nnrp1.deja.com...
> Hi,
> does anybody have a script that will report the table
> differences between two schemas? I would like to compare
> two schemas and report any differences in e-mail.
> Thanks for your help in advance.
> Norbert Kirkpatrick
> norbertk_at_wpds.com
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Apr 04 2000 - 00:00:00 CDT