OraFAQ Forum: Server Utilities » Where we need to use DIRECT = TRUE for direct path ?

Home » RDBMS Server » Server Utilities » Where we need to use DIRECT = TRUE for direct path ?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Where we need to use DIRECT = TRUE for direct path ? [message #174433]

Mon, 29 May 2006 04:20

prabhuapps
Messages: 79
Registered: June 2005
Location: Bangalore

Member

Dear All,

Where i need to mention DIRECT = TRUE for direct path loader method?

Regards,
Prabhu

Report message to a moderator

Re: Where we need to use DIRECT = TRUE for direct path ? [message #174439 is a reply to message #174433]

Mon, 29 May 2006 04:29

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

in command line.

sqlldr userid=username/password control=myctl.ctl direct=true

Report message to a moderator

Re: Where we need to use DIRECT = TRUE for direct path ? [message #174469 is a reply to message #174439]

Mon, 29 May 2006 05:35

Littlefoot
Messages: 21811
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

And what are the differences between conventional and direct load paths?

Oracle documentation

A conventional path load executes SQL INSERT statements to populate tables in an Oracle database.

A direct path load eliminates much of the Oracle database overhead by formatting Oracle data blocks and writing the data blocks directly to the database files. A direct load does not compete with other users for database resources, so it can usually load data at near disk speed.

Read more about it here.

Report message to a moderator

Re: Where we need to use DIRECT = TRUE for direct path ? [message #174657 is a reply to message #174433]

Tue, 30 May 2006 03:24

prabhuapps
Messages: 79
Registered: June 2005
Location: Bangalore

Member

Thanks Guys

Report message to a moderator

Previous Topic:	import only source (procs, funcs, etc.)
Next Topic:	How to write a SQLLDR File that ignores the trailing records

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 01 01:16:47 CDT 2024