Re: Does SELECT start a transaction?
- From: "Don Seiler" <don@xxxxxxxxx>
- To: knightjck_work@xxxxxxxxx
- Date: Thu, 5 Apr 2007 15:28:20 -0500
A normal select alone doesn't begin a transaction. You could put it
inside a SET TRANSACTION READ ONLY block though. Then you'll be
hangin' tough with the right stuff.
Don.
On 4/5/07, Jonathan Knight <knightjck_work@xxxxxxxxx> wrote:
We've scoured the documentation and are still a little fuzzy :-) on this ...
We're trying to convert some SQL*Loads from conventional to direct and the
Oracle Documentation states that one of the requirements is that there are no
active transactions on the destination table. Obviously SELECT ... FOR UPDATE
would begin a transaction, but what about a simple SELECT?
Many thanks,
Jon Knight
--
Don Seiler
http://seilerwerks.blogspot.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
