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