| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: SQL*Loader question
$ 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).
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).
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). Received on Tue Jun 04 2002 - 11:53:28 CDT
 |
 |