Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Query that returns 2 different results in 9iRAC and 10gRac

Re: Query that returns 2 different results in 9iRAC and 10gRac

From: Brian <brian_at_databaseknowledge.com>
Date: 11 Mar 2005 11:41:03 -0800
Message-ID: <1110570063.167753.295480@g14g2000cwa.googlegroups.com> 





I understand the data is in flux.  It's not changing so much as to
loose all the data from the other node.



The result of query should be consistent.  The result should not be
dependant on the execution plan.  Use Plan1 get Result 1, use Plan 2
get result 2...huh?



Why doesn't the query error saying "Temp table is not found"?
After all you are saying that the WITH clause doesn't find the temp
table that is materialized at the other node.
Received on Fri Mar 11 2005 - 13:41:03 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US