Re: changing the isolation level

Marten Lehmann wrote:
> Hello,
>
> I have an upcoming migration from Sybase to Oracle and a problem I ran
> into is the different isolation level for transactions.
>
> We have several applications here where one application is creating or
> changing entries and then another application is performing some tests
> on these changed data. The changes or creations are not commited until
> the tests have been successfully. With Sybase, the testing application
> could see the new and changed records, but with Oracle, it cannot see
> them. How can I change the isolation level in Oracle for this
> application? Or do I have so set it for the whole Oracle server?
>
> Regards
> Marten

When I teach Sybase to Oracle classes for DBAs and developers the part I emphasize most is the difference in underlying architecture and concepts.

A rewrite is the appropriate thing to do for many reasons. One because it is necessary with respect to this issue. Secondly because there are likely many other attributes of your Sybase application such as the use of temp tables and single-row processing that should be rewritten.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org