Re: How to compare DB Tables in different Instances

Hi,

>We have a need to compare the data in tables in a base Instance
>with the new DB instance thats created for a Client.

I'm thinking about a database link, but don't know if this is correct.

>Request suggestions on how to automate comparing tables
>and possibly listing descrepancies.

I don't know if it's possible to create triggers between instances. It sure isn't recommended for performance.

But of course you can use sql-statements to list the discrepancies. Maybe you even want to create a generic script using the user_tab_columns table.

• Martin Jesterhoudt
• martinj(replace this by @)xs4all.nl

  ---