Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> question re sqlldr direct load

question re sqlldr direct load

From: John Dunn <jdunn_at_sefas.com>
Date: Thu, 20 Jan 2005 10:28:03 -0000
Message-ID: <000b01c4feda$ba056d60$3e04050a@johnman>


As I understand it direct load requires exclusive access to the table.

What happens if someone tries to do a select or delete on the table whilst the load is in progress?
Presumably they will just wait for the lock to be released?

John

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jan 20 2005 - 05:29:40 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US