RE: SQL*Loader

From: Henry Poras <HPoras_at_ctp.com>
Date: Fri, 30 Jun 2000 13:52:27 -0400
Message-Id: <10544.110977@fatcity.com>

Thought I had something tucked away in my notes on this. T. Kyte wrote a reply to a similar question in the comp.databases.oracle.tools newsgroup. You can search for it through dejanews. It is dated 9/2/98, titled 'How to skip the first two fields in sql*loader'.

Roughly it says that SQL*Loader by itself cannot do this. However, on a UNIX system you can cut the file and pipe the output to Loader. He also does this with a pl/sql sql*loader combination.

If you have any trouble finding the note, just send me an e-mail and I can fax over a copy.

Henry

		-----Original Message-----
		From:	dgoulet_at_vicr.com [mailto:dgoulet_at_vicr.com]
		Sent:	Friday, June 30, 2000 1:05 PM
		To:	Multiple recipients of list ORACLE-L
		Subject:	SQL*Loader

		    I hope somebody may have an idea on this.  I've already
done the RTFM thing
		and experimenting with no luck.

		    My problem is that we have an automatic tester that
generates ASCII comma
		delimited text files of it's results to be loaded to the
database.  One of these
		files has a column in it that is no longer wanted in the
database.  Regrettably
		it's going to be some time before the test engineering folks
get around to
		removing it from the file, but the engineers want it out
like yesterday and
		wouldn't you know it's right in the middle of each line.
The headache is that
		nothing in this results file is fixed in size.  The records
are from 60 to 80
		characters long, with trailing nullcols, and the fields
therein vary from test
		to test.  Even this particular column varies from 1 to 5

characters.

                    Anyone out there got any idea on how to tell SQL*Loader to ignore this

                field??? My other alternative if Pro*C, but that may take a while too.

                Thanks & Happy 4th for those of you in the States.

		Dick Goulet
		-- 
		Author: 
		  INET: dgoulet_at_vicr.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

Received on Fri Jun 30 2000 - 12:52:27 CDT