| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Generating a SQLLDR Sequence Number
Tom:
Ran into another problem. I need to generate a sequence number for one of the DB columns. Here is the CTL code:
document_number sequence (max,800000,1),
It runs but I keep getting the 800000 that doubles for each record (800000, 1600000, 3200000, etc.). The book only shows the syntax but doesn't give an example of how it works.
Any ideas?
Thanks,
Ken
-----Original Message-----
Sent: Tuesday, December 04, 2001 7:35 AM
To: Multiple recipients of list ORACLE-L Subject: RE: SQL Loader Commit Point?
Ken
Did you look at the Sql*Loader log file? Maybe all your records were rejected and placed into the .bad file? Does a .bad file exist? Sql*Loader does not really consider rejected records an error - it just moves them there.
Hope this helps.
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
Sent: Monday, December 03, 2001 4:33 PM
To: Multiple recipients of list ORACLE-L
I am working on a control script that I have restricted to only loading 5 records as a test. Basically I am taking data from the load file and putting it into a table SQL Loader runs and gives me this.
SQL*Loader: Release 8.1.7.0.0 - Production on Mon Dec 3 15:22:26 2001
(c) Copyright 2000 Oracle Corporation. All rights reserved.
Commit point reached - logical record count 5
When I do a select on this table I get no rows selected.
I don't get an error message from SQL Loader.
So any ideas as to what the problem is?
Thanks,
Ken Janusz, CPIM
Database Conversion Lead
Sufficient System, Inc.
Minneapolis, MN
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ken Janusz
INET: ken.janusz_at_sufsys.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 Dec 04 2001 - 10:16:45 CST
 |
 |