Oracle Class – Wissem's Oracle and NOSQL Tips – Tunisia's First Oracle, NOSQL Website

INTRODUCTION

Today, using my test Oracle 11g Release 2 on one virtual machine, to test the export of one schema.
I was exporting schema n 11.2 database With 10g Client. The export Gave an Ora-01455.

The export failed with the following detailed error :
….
. exporting referential integrity constraints
. exporting triggers
EXP-00056: ORACLE error 1455 encountered
ORA-01455: converting column overflows integer datatype
EXP-00000: Export terminated unsuccessfully
…..

I remember I have solved this issue one month ago when one Oracle user posted the issue on the OTN forum. I help him to fix the issue.
After fixing the problem, I thought it would be a good idea to post the solution here so everyone can solve it in the future;

THE ERROR

. exporting referential integrity constraints
. exporting triggers
EXP-00056: ORACLE error 1455 encountered
ORA-01455: converting column overflows integer datatype
EXP-00000: Export terminated unsuccessfully

This is an Oracle Bug. The root cause is that the converted form of the specified expression was too large for the specified datatype. (from ora-code.com web site).

SOLUTION

I have fixed the problem using one of the following solutions, Therefore, this cannot offer any guarantee of fix for such situations.

Solution 1 : Try with an Oracle 11g Release 2 EXP client against the Oracle 11g Release 2.
Solution 2 : Use the triggers=n option, that allows an export of a schema made by an Oracle 10.2 client against an Oracle 11g release 2 to complete successfully.

The article is also posted here in Oracle mix :
https://mix.oracle.com/group_messages/149104-how-do-i-fix-ora-01455-error-on-11g-release-oracle-database

Nice Reading and Thank you,
Wissem EL KHLIFI