Oversized LOB filename encountered.

Database
Enthusiast

Oversized LOB filename encountered.

I am trying to import data in to the teradata table using bteq script from a file.  I am getting the following error.

 *** Error: Oversized LOB filename encountered.

 *** Warning: Out of data.


Bteq script: 

.import vartext '|' LOBCOLS=1 file='/etl/tst/scripts/edw/counts1.dat';

using (CNTNT CLOB(2097088000),UNQ_ID  VARCHAR(26)) insert into WORK.ETL_12(CNTNT,UNQ_ID) values(:CNTNT,:UNQ_ID);

Table ddl: 

CREATE SET TABLE WORK.ETL_12 ,NO FALLBACK ,

     NO BEFORE JOURNAL,

     NO AFTER JOURNAL,

     CHECKSUM = DEFAULT,

     DEFAULT MERGEBLOCKRATIO

     (

      CNTNT CLOB(2097088000) CHARACTER SET LATIN,

     UNQ_ID INTEGER NOT NULL)

PRIMARY INDEX pi_ETL_12(UNQ_ID );

thanks


1 REPLY
Junior Supporter

Re: Oversized LOB filename encountered.

Hi.

Filename must go either without single quotes or with double quotes.

Cheers.

Carlos.