try replacing document_number sequence (max,800000,1),
with document_number sequence (max,1), sqlloader is taking 800000 as your increment... docs show only 2 arguments for sequence function... hth > -----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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: Mercadante, Thomas F > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: Ken Janusz > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). -- Maria Aurora VT de la Vega (OCP) Database Specialist Philippine Stock Exchange, Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Maria Aurora VT de la Vega INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
