Re: Cache and Oracle9i

I can only think you might have enabled flashback by error. That would mean a select is taking place from a time before the updates took place, hence they are invisible. But since flashback is only enabled at the session level with a rather obscure bit of syntax, I find it hard to believe you;ve enabled it by default.

The only other possibility I can think of is that you have version-enabled the table, using the dbms_wm package, and have travelled to a different workspace for the selects than the one where you did the updates. That would again result in committed updates being invisible to a subsequent select. But travelling to a different workspace is not exactly something you pull off by accident, either.... so that one's hard to believe too!

I am of course presuming that you actually committed the modification of the elements before trying to see them, and/or that you are selecting in the same session as you updated -otherwise, this is perfectly normal behaviour.

Any other clues? (Hint: a script of your session doing the updates and selects would be helpful)

Regards
HJR "Olivier Maurice" <omaurice_at_nospam.kheops-tech.com> wrote in message news:33S98.37741$8N.4637850_at_carnaval.risq.qc.ca...
> Hi!
>
> I have a small problem and I can't seem to find the solution (which is
> probably stupid!)
>
> I have an Oracle9i database running on my machine. I use Oracle Spatial to
> store geometric elements. When I modify the elements, the changes are made
> correctly to the field. However, when I do a select on the same field, it
> returns the original value.
>
> Is this a cache problem? Or something else? Any help would be appreciated.
>
> Olivier
>
> P.S: I forgot to mention that in versions 8.1.6 and 8.1.7, everything
works
> fine.
>
>
Received on Tue Feb 12 2002 - 07:34:01 CST