Re: Quick and dirty way to compare table contents

  • From: "Ranko Mosic" <ranko.mosic@xxxxxxxxx>
  • To: "Jared Still" <jkstill@xxxxxxxxx>
  • Date: Sat, 25 Feb 2006 18:42:41 -0500

It can't be done that way, problem here is to compare if table content is
the same between
two environments.

BTW, I still didn't solve that problem with optimizer cost as function of ts
block size.
I declared victory prematurely. Any ideas ?


On 2/25/06, Jared Still <jkstill@xxxxxxxxx> wrote:
>
> 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@xxxxxxxxxxxxxxx> 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
> >
>
>


--
Regards,
Ranko Mosic
Contract Senior Oracle DBA
B. Eng, Oracle 10g, 9i Certified Database Professional
Phone: 416-450-2785
email: mosicr@xxxxxxxxxx
http://ca.geocities.com/mosicr@xxxxxxxxxx/ContractSeniorOracleDBARankoMosicMain.html

Other related posts: