SQLLoader(DIRECT=FLASE, PARALLEL=TRUE) [message #399127] |
Mon, 20 April 2009 18:09 |
shrinika
Messages: 306 Registered: April 2008
|
Senior Member |
|
|
Hello,
In Oracle SQLLoader, we have a command line parameter called PARALLEL. My understanding is,
when we use PARALLEL command line parameter in sqlloader, Oracle use PARALLEL Load.
It is equivalent to using PARALLEL hint in INSERT statement(It is apparently DIRECT Load)
In this case, if we use PARALLEL option in conventional load(DIRECT=FALSE), it is contradictory...
Conventional load is like regular INSERT conventional method(Non Direct load).
This combination(DIRECT=FALSE, PARALLEL=TRUE) really confusing me...
Can any one help me to understand this... Thanks
C:\Loader>sqlldr control=case1.ctl userid=scott/tiger@orcl file=case1.ctl log=ca
se1.log parallel=TRUE direct=FALSE
SQL*Loader: Release 10.1.0.2.0 - Production on Mon Apr 20 19:03:22 2009
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Commit point reached - logical record count 6
C:\Loader>
|
|
|
|
|
|
|