| 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: Generating a SQLLDR Sequence Number
Ken,
This is what I did once to do a similar exercise. I defined a seq dk_seq as
in my case in the database and used the following control file. The next
value of sequence should depend on how you define the sequence.
LOAD DATA
INFILE 'sysx.csv'
TRUNCATE
INTO TABLE dk_tmp
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
trailing nullcols
(
CUSIP char, ISIN char, SMF char, STATUS char, REASON char, ELG_DATE char, CURRENCY char, MATURITY char,seqno "dk_seq.nextval" )
-----Original Message-----
Sent: Tuesday, December 04, 2001 11:01 AM
To: Multiple recipients of list ORACLE-L
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).
<FONT SIZE =
1>****************************************************************************This e-mail and any attachments may contain confidential and privileged information. If you are not the intended recipient, please notify the sender immediately by return e-mail, delete this e-mail and destroy any copies. Any dissemination or use of this information by a person other than the intended recipient is unauthorized and may be illegal. Unless otherwise stated, opinions expressed in this e-mail are those of the author and are not endorsed by the author's employer.</FONT>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kumar, Dharminder
INET: Dharminder.Kumar_at_bmonb.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). Received on Fri Dec 07 2001 - 10:25:57 CST
 |
 |