Home » RDBMS Server » Server Utilities » SQLLoader(DIRECT=FLASE, PARALLEL=TRUE) (oracle10g)
SQLLoader(DIRECT=FLASE, PARALLEL=TRUE) [message #399127] Mon, 20 April 2009 18:09 Go to next message
shrinika
Messages: 267
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>
Re: SQLLoader(DIRECT=FLASE, PARALLEL=TRUE) [message #399130 is a reply to message #399127] Mon, 20 April 2009 18:20 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
do the following
C:\Loader>sqlldr help=yes
& read & understand what is presented

http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/ldr_params.htm#i1004682

[Updated on: Mon, 20 April 2009 18:27]

Report message to a moderator

Re: SQLLoader(DIRECT=FLASE, PARALLEL=TRUE) [message #399141 is a reply to message #399130] Mon, 20 April 2009 21:12 Go to previous messageGo to next message
shrinika
Messages: 267
Registered: April 2008
Senior Member
Thanks. I got it.
Re: SQLLoader(DIRECT=FLASE, PARALLEL=TRUE) [message #399162 is a reply to message #399127] Mon, 20 April 2009 23:32 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Do not use PARALLEL for 6 rows.

Regards
Michel
Re: SQLLoader(DIRECT=FLASE, PARALLEL=TRUE) [message #399296 is a reply to message #399162] Tue, 21 April 2009 08:34 Go to previous message
shrinika
Messages: 267
Registered: April 2008
Senior Member
Thanks for your comments Michel. After reading the document, i understand that, PARALLEL is only for DIRECT PATH Load.
I do understand that, it is not worth to use PARALLEL for 6 rows.. Just testing purpose, i used this parameter.... Laughing

[Updated on: Tue, 21 April 2009 08:47]

Report message to a moderator

Previous Topic: SQL*LDR fails ORA-12154: TNS:could not resolve service name, but SQL*PLUS works fine
Next Topic: CONSISTENT versus OBJECT_CONSISTENT in EXP
Goto Forum:
  


Current Time: Sat Dec 10 20:17:57 CST 2016

Total time taken to generate the page: 0.14155 seconds