Re: question re sqlldr direct load

  • From: "Mark J. Bobak" <mark@xxxxxxxxx>
  • To: jdunn@xxxxxxxxx
  • Date: Thu, 20 Jan 2005 08:30:58 -0500

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.


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
> --
> //

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


Other related posts: