Inserting CLOB's with SQL Loader
From: <mb71_at_my-deja.com>
Date: Mon, 01 Nov 1999 15:26:42 GMT
Message-ID: <7vkbfd$4ok$1_at_nnrp1.deja.com>
[Quoted] When I try to insert CLOB's using SQL Loader the CLOB field only receives the first 100 bytes the the CLOB. Has anyone encountered this before? A sample loader file is attached.
Date: Mon, 01 Nov 1999 15:26:42 GMT
Message-ID: <7vkbfd$4ok$1_at_nnrp1.deja.com>
[Quoted] When I try to insert CLOB's using SQL Loader the CLOB field only receives the first 100 bytes the the CLOB. Has anyone encountered this before? A sample loader file is attached.
Thanks,
Mike
LOAD DATA
INFILE *
INTO TABLE CURRENT
APPEND
FIELDS TERMINATED BY ','
(
TITLE CHAR,
FNAME FILLER CHAR,
"DATA" LOBFILE (FNAME),
ID SEQUENCE(MAX,1))
BEGINDATA
Test Title,990941450410.txt
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Mon Nov 01 1999 - 16:26:42 CET