Re: SQL*Loader question

Get a copy of SQL*Loader the Definitive Guide by Gennick & Mishra / O'Reilly.

You can use command-line parameters in the control file via a the OPTIONS command. For example:

OPTIONS (parameter=value[,parameter=value...])

You can use:
SKIP=logical_record_count
LOAD=logical_record_count (the number of records to load) etc.

You can also extract the number of rows you want to load and place the data in the control file. Use the keyword BEGINDATA data
data
data

My $0.02 worth,
Ken Janusz, CPIM

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Tuesday, June 04, 2002 11:53 AM

> $ sqlldr help=y
> userid ORACLE username/password
> control Control file name
> log Log file name
> bad Bad file name
> data Data file name
> discard Discard file name
> discardmax Number of discards to allow
> skip Number of logical records to skip
> load Number of logical records to load
>
> -----Original Message-----
> Sent: Tuesday, June 04, 2002 12:09 PM
> To: Multiple recipients of list ORACLE-L
>
>
>
> I don't know if you can load the first 100 records, but you could load
> the last 100 by setting the "skip" value to the total - 100.
>
> HTH,
>
> Beth
>
> -----Original Message-----
> Sent: Tuesday, June 04, 2002 11:39 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Oracle 8.1.6.3 on Sun 2.6.
>
> I have tried reviewing the docs, but I didn't see anything that answered
> the
> question. Is it possible to limit the number of records being loaded?
> We
> have a file that has records in the 6 digit range. I'd like to test the
> controlfile, but I don't want to load the whole file. Is there a way to
> tell loader to only load, say the 1st 100 records?
>
> TIA
>
> Terry Ball, DBA
> Birch Telecom
> Work: 816-300-1335
> FAX: 816-300-1800
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ball, Terry
> INET: TBall_at_birch.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Seefelt, Beth
> INET: Beth.Seefelt_at_TetleyUSA.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Toepke, Kevin M
> INET: ktoepke_at_trilegiant.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: KENNETH JANUSZ
  INET: kjanusz_at_att.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (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).