Oracle-L: RE: error 1406 with export

From: Carlos <carlos.drach_at_tallion.com>
Date: Fri, 02 May 2003 07:36:51 -0800
Message-ID: <F001.0058E0BA.20030502073651@fatcity.com>

Oracle 9.0.1.0.0 on SunOS 5.8

-----Original Message-----
Sent: Wednesday, April 30, 2003 10:22 PM To: Multiple recipients of list ORACLE-L

versions please - there was a bug in 8.05 and 8.1.5 related to this issue

>>> carlos.drach_at_tallion.com 04/30/03 04:01PM >>>
Hi,
direct to point:

exp <mailto:userid=taxdev/******@sundb01.tallion.com.ar> userid=taxdev/******@sundb01.tallion.com.ar tables=report query=\"where ujc=4 and report_id=204\"

Table REPORT will be exported in conventional path.

EXP-00008: ORACLE error 1406 encountered
ORA-01406: fetched column value was truncated
EXP-00000: Export terminated unsuccessfully

table report is:
SQL> desc report

 REPORT_ID     NOT NULL NUMBER(14)
 UJC           NOT NULL NUMBER(14)
 NAME          NOT NULL VARCHAR2(100)
 QUERY         NOT NULL VARCHAR2(4000)
 PARAMETERS_HTML        CLOB
 HTML_XSL               SYS.XMLTYPE
 PDF_XSL                SYS.XMLTYPE
 TMP                    CLOB

Carlos Drach

Tallion Ltd.

Reconquista 1166 5to piso
C1003ABX Buenos Aires, Argentina
(54) (11) 4313-5391 / 4958

<mailto:carlos.drach_at_tallion.com> carlos.drach_at_tallion.com

<http://www.tallion.com/> http://www.tallion.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: John Shaw
  INET: John.Shaw_at_correctionscorp.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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 subscribing).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Carlos
  INET: carlos.drach_at_tallion.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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 subscribing).

Received on Fri May 02 2003 - 10:36:51 CDT