Re: Does SELECT start a transaction?

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_at_yahoo.com> 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
--
http://www.freelists.org/webpage/oracle-l