Love Sun

11.2.0.1.0 exp ORA-01455: converting column overflows integer datatype 错误处理

环境:客户端和服务器端在一台机器,都是11.2.0.1.0
用exp 导出报错。
exp csc/passwd file=csc_.dmp log=csc_.log owner=csc
报错如下:
. exporting synonyms
. exporting views
EXP-00056: ORACLE error 1455 encountered
ORA-01455: converting column overflows integer datatype
EXP-00000: Export terminated unsuccessfully

解决方法,分析一下需要导出的用户
SQL> exec dbms_stats.gather_schema_stats(ownname => ‘csc’,estimate_percent => 1);

再执行exp,一切ok。

refer to:http://blog.itpub.net/25027760/viewspace-775651/

dbms_stats.gather_schema_stats官方文档

Tagged on:

Leave a Reply

Your email address will not be published. Required fields are marked *