Oracle-L: Re: SQL Loader

From: Sergey V Dolgov <dsv_at_pptus.oilnet.ru>
Date: Thu, 16 May 2002 00:53:20 -0800
Message-ID: <F001.00461FD2.20020516005320@fatcity.com>

Hello Shankar,

You can'n rely on rowid in your case. It would be much better to add additional field into your table and write rownum to it. You can generate record number automatically by SQL Loader. Here is simple example how to do it:

LOAD DATA
INFILE 'yourfile.dat'
BADFILE 'load.bad'
INSERT INTO TABLE YOUR_TABLE
trailing nullcols
( R_NUMBER RECNUM,
TABLE_ROW) you can also use SEQUENCE keyword instead of RECNUM.

Thursday, May 16, 2002, 2:53:21 PM, you wrote:

RCCC> Hi friends,
RCCC>         I have to load a input file into a oracle table . The table has only
RCCC> one field which will store each line as a single row . The order of the file
RCCC> is very important for my further process. sometimes the order of the file is
RCCC> changed when it is stored in the file. there is no sequence or unique id
RCCC> present in the file. 
RCCC>         Can you tell me why this ordering is being changed .when u re-run
RCCC> the sql loader , it is working properly. not able to simulate why this is
RCCC> happening .
RCCC>         Is it any way to specify in loader just fetch a single row from the
RCCC> file and write it before fetching next.

RCCC> Best Regards,
RCCC> Shankar

--

Best regards,

 Sergey                            mailto:dsv_at_pptus.oilnet.ru

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Sergey V Dolgov
INET: dsv_at_pptus.oilnet.ru

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 Thu May 16 2002 - 03:53:20 CDT