Re: Different results

From your description I can not understand what you are doing. Can you clarify what you are doing and perhaps give some more details on the nature of the query and whether you are logging any errors?

Daniel A. Morgan

Frederic Mockel wrote:

> 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 Wed Mar 21 2001 - 00:21:39 CST