Re: Generating a SQLLDR Sequence Number

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: 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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Mercadante, Thomas F
> INET: NDATFM_at_labor.state.ny.us
>
> 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: 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).
>
> <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).

--
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: mtdelavega_at_pse.org.ph

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).