Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Error 1455 doing export

Error 1455 doing export

From: Philip Ross <philip_ross_at_my-deja.com>
Date: Thu, 11 Oct 2001 10:06:06 +0100
Message-ID: <3idx7.1304$096.186924@news6-win.server.ntlworld.com>


I am getting an error whilst doing an export from an Oracle 8.1.5 database on Solaris. The error that occurs is:

EXP-00008: ORACLE error 1455 encountered ORA-01455: converting column overflows integer datatype

The structure of the table being exported is:

(
  A NUMBER(38, 0) NOT NULL,
  B VARCHAR2(200),

  C BLOB,
  D DATE,
  E DATE,
  F VARCHAR2(30),
  G VARCHAR2(30),
  H VARCHAR2(20) NOT NULL,

  I VARCHAR2(1) DEFAULT 'N',
  J VARCHAR2(50)
)

Any ideas as to what could be causing this error?

Thanks,

Phil Received on Thu Oct 11 2001 - 04:06:06 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US