Re: cant get the correct num of rows from Oracle. in 2 SQL servers ( sql 7.0 and SQL 2000)

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 10/19/04 

Date: Tue, 19 Oct 2004 13:44:08 +0200

Is there a tool like Profiler available for Oracle? If so, can you trace the query submitted to
Oracle and see if they are the same? What if you execute the same query directly on the Oracle
Server? What number of rows is the correct number? 

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Melih SARICA" <melihsarica@hotmail.com> wrote in message 
news:%23pKPi9ctEHA.2520@tk2msftngp13.phx.gbl...
> Ty tibor..
>
> Query is the same
>
> select count(*) from openquery(baanb,'select t$item from baan.ttiitm001501')
>
> in SQL server 7.0 this query returns 49439
>
> in SQL server 2000 it returns 49340
>
>
> and not only in this query .. if number of rows returned from the openquery
> statement get biggers number of lost rows get bigger too
>
>
>
>
>
>
>
>
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com> wrote in
> message news:Oi34g5ctEHA.636@TK2MSFTNGP09.phx.gbl...
>> Possibly handling of NULLS can cause a difference. Can you post the two
> queries?
>>
>> -- 
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>>
>> "Melih SARICA" <melihsarica@hotmail.com> wrote in message
>> news:%23szluxctEHA.3156@TK2MSFTNGP12.phx.gbl...
>> >I ve got an Oracle 9. server running on AIx.
>> >
>> > and One SQL Server 2000 Sp 3on w2k
>> >  and SQL server 7 on Winnt 4.0
>> >
>> >
>> > i did link this Oracle server on both SQL serevrs. When run an simple
> SQL
>> > query i got different results.
>> >
>> > Num of rows are always different In SQL server 7.0 i got 49430 rows(
> when i
>> > check in oracle its correct)
>> >                                                    In SQL SErver 2000 i
> got
>> > 49336 rows.
>> >
>> > Any idea ?
>> >
>> >
>> >
>> >
>>
>>
>
>

Relevant Pages
Loading