Re: sql loader question

Thursday, July 3, 2003, 5:40:37 AM, you wrote: bnini> SQL*Loader reads a set of records from a file, generates INSERT bnini> commands,

This is the key right here. A conventional path load generates INSERT statements. A direct path load does not. A direct-path load passes preformatted blocks to the database. The term "direct path" comes from the fact that SQL*Loader
(the client) formats a database block and sends it to the
server to be written directly to the disk. No SQL processing is involved.

bnini> Answer : Direct-path load , ( It is said "free blocks" which implies
bnini> "Direct-Path Load", because "Conventional-Path Load" also use
bnini> partially filled blocks. )

Was this from an Oracle exam? I hope not. It's ironic the person writing the test intended for you to notice the subtle mention of "free blocks" when they themselves didn't realize that direct path loads do not generate INSERT statements.

bnini> Shouldn't it be conventional path load, because insert commands are bnini> being used .

Yes. You are correct.

Best regards,

Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED]

Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and
include the word "subscribe" in either the subject or body.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jonathan Gennick
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).