Home » RDBMS Server » Server Utilities » export error : converting column overflows integer datatype (solaris 10 oracle 10.2.0.2)
export error : converting column overflows integer datatype [message #333902] Mon, 14 July 2008 16:30 Go to next message
kumar.joy
Messages: 69
Registered: August 2007
Location: morrisville
Member
experts,

i am getting export error. my export is terminated successfully with warnings. please find the details.
i did not get much information to analyze this problem. can any one help me to fix this issue
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
Export done in UTF8 character set and AL16UTF16 NCHAR character set

About to export specified tables via Direct Path ...
Current user changed to BILLING
. . exporting table                         TXN_BB
. . exporting partition                    TXN_BB_0708   41953026 rows exported
EXP-00008: ORACLE error 1455 encountered
ORA-01455: converting column overflows integer datatype
Export terminated successfully with warnings

Re: export error : converting column overflows integer datatype [message #333903 is a reply to message #333902] Mon, 14 July 2008 16:42 Go to previous message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
Possible bug.
Try with including: INDEXES=n STATISTICS=none
Previous Topic: listing the tables contained in a dump file
Next Topic: sql loader question
Goto Forum:
  


Current Time: Thu Dec 08 18:29:47 CST 2016

Total time taken to generate the page: 0.08644 seconds