Re: question re sqlldr direct load

John,
Direct load takes a TM enqueue on the table in e'X'clusive mode. This effectively blocks all other DML (and DDL, for that matter) against this table. Non-direct DML takes a TM enqueue in 'S'hared mode, which will queue behind the 'X' mode lock taken by the direct load.

Selects, however, will not be affected.

-Mark

On Thu, 2005-01-20 at 05:28, John Dunn wrote:

> 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

--
Mark J. Bobak
mark_at_bobak.net
"Science is the belief in the ignorance of experts."  --Richard P.
Feynman


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