Re: Quick and dirty way to compare table contents

Of course, the thought of fixing the problem comes to mind.

eg. Why is there data in two tables that much match?

If you need two tables, designate one as the source and create the other as a Materialized View.

There are usually other problems to overcome to accomplish that, but should be easier than a work-around like comparing data.

Jared

On 2/22/06, Bobak, Mark <Mark.Bobak_at_il.proquest.com> wrote:
>
> I think you need to have a conversation with your boss that goes something
> like this:
>
> "Hey boss, you can ask me to do something, or you can tell me how to do
> it....but you can't do both!" ;-)
>
> My point is, he wants an answer to a question, that being "Is the data
> in these tables in these two databases the same or not?" As long as the
> method is valid, what business does he have dictating what methods should
> not be used?
>
> I know, there are impossible bosses all over the place, but, really, he
> needs to let you do your job.
>
>
> Ok, here's an actual attempt to answer your question:
> Sp
>

--
http://www.freelists.org/webpage/oracle-l