RE: SQL Loader question

From: Steven Monaghan <MonaghaS_at_mscdirect.com>
Date: Thu, 14 Sep 2000 08:38:41 -0400
Message-Id: <10619.116963@fatcity.com>

How about using functions on the second field and treating it as fixed width:
rtrim(translate(translate, '>>', null), '<<', null) should do it (off of the top of my head...)

Specify a bad file for the records and sql*load the bad file into your other table after the first run is completed.

List, any comments?
Steve

Steven Monaghan
Oracle DBA
MSC Industrial Direct Co., Inc.
Melville, NY
MonaghaS_at_mscdirect.com

> -----Original Message-----
> From: vipul desai [mailto:desaivipul_at_usa.net]
> Sent: Thursday, September 14, 2000 3:16 AM
> To: Multiple recipients of list ORACLE-L
> Subject: SQL Loader question
>
>
> Hi friends,
>
> I wanted to upload a ASCII file into the database using
> sql*loader. The
> format of the file is mixed, by that i mean first 10 fields
> are of fixed
> length and last 10 are of variable length having the
> delemiter as << start and
> >> end.
>
> Using single control file i want to upload the data into
> the database.
>
> One more thing if there is any exception or error in
> uploading data to the
> database it should insert the same row into other table with
> one field of the
> type logn. I mean without breaking into various fields it
> should append the
> record into other table.
>
> Can any one help on the same. If this is not possible
> through SQL*Loader and
> u are suggesting UTL_FILE then i think it would not be good
> option for me
> because filesize si 20 MB and processing with the UTL_FILE
> whould decrease the
> speed.
>
> Thanks
> -Vipul
>
> ____________________________________________________________________
> Get free email and a permanent address at
http://www.netaddress.com/?N=1

-- 
Author: vipul desai
  INET: desaivipul_at_usa.net

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 Sep 14 2000 - 07:38:41 CDT