Different results

From: Frederic Mockel <frederic.mockel_at_gillardon.de>
Date: Tue, 20 Mar 2001 18:47:09 -0000
Message-ID: <3ab7962a$0$3714$4dbef881@businessnews.de.uu.net>

Dear all,

i have a problem.

We work on Oracle 8.0.6.2 on HP-UX. We have very huge database ( 12 GB) with few very big tables ( two tables have 43 million rows, the next on has 10 millions rows).

During the night we have a batch-job manipulating the data. We have updates, deletes and massive inserts.

To get the result we have a union-all-query.

And now the effect:

When we run the query against the database after manipulating the data we got now result for the second statement of the query.

When we do an complete reorg we got a (right) result for both statements in the query.

How can this happened ?

Freddy Received on Tue Mar 20 2001 - 12:47:09 CST