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>


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-6911

----------------------------------------------------------------
Received on Fri Jul 23 1993 - 23:48:12 CEST

Original text of this message