Read Only Transactions
From: R_M <rmurcia_at_excite.com>
Date: 13 Aug 2003 11:36:17 -0700
Message-ID: <d7d116da.0308131036.3f677bc4_at_posting.google.com>
Date: 13 Aug 2003 11:36:17 -0700
Message-ID: <d7d116da.0308131036.3f677bc4_at_posting.google.com>
Hi:
I am new to Oracle and have a probably trivial concurrency question.
How is an ROT implemented ?
Suppose I create an ROT
Is the contents of tables A and B saved aside so any concurrent update
and then issue the following commands:
select * from table A where colx=3
select * from table A where colx != 3
select * from table B
select * from table A where colx=2
select * from table B
Or are tables A and B blocking updates until I close the ROT.
Thanks
Ricardo Received on Wed Aug 13 2003 - 20:36:17 CEST