Does SELECT start a transaction?

From: Jonathan Knight <knightjck_work_at_yahoo.com>
Date: Thu, 5 Apr 2007 13:04:51 -0700 (PDT)
Message-ID: <648113.8530.qm@web60616.mail.yahoo.com>

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  

---

We won't tell. Get more on shows you hate to love (and love to hate): Yahoo! TV's Guilty Pleasures list. http://tv.yahoo.com/collections/265

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Apr 05 2007 - 15:04:51 CDT