Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: oracle sqlloader

Re: oracle sqlloader

From: Brian Peasland <dba_at_remove_spam.peasland.com>
Date: Wed, 30 Jul 2003 17:38:57 GMT
Message-ID: <3F2802B1.14098905@remove_spam.peasland.com>


All of these questions are documented in the Oracle 9i Utilities Guide, particularly the section on SQL*Loader. You can find a copy at http://tahiti.oracle.com. But a quick recap can't hurt....

> what is sqlloader.... when it is used

It is a utility to load data from a flat file into Oracle tables.

> what is control file when it is used

It is used to give SQL*Loader a list of parameters to control SQL*Loader's behaviour.

> what is log file when it is used

It is the file which will show the SQL*Loader's log of activity

> what is bad file when it is used

It holds those records from the flat file which are "bad". For more information on that, you'll have to refer to the docs....

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"
Received on Wed Jul 30 2003 - 12:38:57 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US