Re: LONGs and SQL*LOADER
From: John E. Kane,x37208 <jkane_at_kona.xerox.com>
Date: 23 Jul 1993 21:48:12 GMT
Message-ID: <22pmas$3eq_at_vine.cp10.es.xerox.com>
)
Date: 23 Jul 1993 21:48:12 GMT
Message-ID: <22pmas$3eq_at_vine.cp10.es.xerox.com>
Create a record with the long field data for each row to be loaded. The field may either be comma delimited or quote bounded. Of course the comma delimited field may not contain any commas nor the quote bounded field contain any quotes. Then described the long field as char(maxvalue). This is used by SQL*Loader to determine the buffer size. The maximum size of the LONG column is 65535 bytes or 64kb.
Example of control file:
LOAD DATA
INFILE '[JKANE.TPS]TPS_01_EB.DAT'
INTO TABLE TPS_ENG_BULLETIN
FIELDS TERMINATED BY ','
( PART_NO char(20), BULLETIN char(1740)
)
See ORACLE RDBMS Utilities User's Guide vers 6.0 page 6-46 5th paragraph.
John E. Kane Information Management Services Xerox Corp. ESAE-345 jkane.es_ae_at_xerox.com 701 S. Aviation Blvd. Voice: (310) 333-7208 El Sequndo, CA 90245-4898 FAX: (310) 333-6911Received on Fri Jul 23 1993 - 23:48:12 CEST
----------------------------------------------------------------