Re: Quick and dirty way to compare table contents

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_at_gmail.com> 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_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
> >
>
>

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

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