Re: question re sqlldr direct load
- From: "Mark J. Bobak" <mark@xxxxxxxxx>
- To: jdunn@xxxxxxxxx
- Date: Thu, 20 Jan 2005 08:30:58 -0500
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
>
>
> --
> //www.freelists.org/webpage/oracle-l
--
Mark J. Bobak
mark@xxxxxxxxx
"Science is the belief in the ignorance of experts." --Richard P.
Feynman
--
//www.freelists.org/webpage/oracle-l
Other related posts:
