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

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 - 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
Messages: 25578
Registered: January 2009
Location: SoCal
Karma: 0
Senior Member
Possible bug.
Try with including: INDEXES=n STATISTICS=none
Previous Topic: listing the tables contained in a dump file
Next Topic: Is it possible database backup tranfer to next version
Goto Forum:

Current Time: Tue Aug 22 10:07:10 CDT 2017

Total time taken to generate the page: 0.06698 seconds