understand locking for SQl LOADER
I am trying to understand locking scenario when invoking sql loader both convention and direct load method.
direct load
Can two direct load run concurrent on same table? is it exclusive lock which took place on table? Can other users run simple select queries when direct load is executing?
Conventional load
Can two conventional load run concurrently on same table? what kind of lock took place here? can other users run simple select queries when conventiional load is executing? Can update statement execute on diffrent set of rows when conventional load is executing on same table?
Thanks
newbee