Oracle数据库数据恢复、性能优化»论坛 › Oracle › Oracle数据库管理 › EXP-00008: ORACLE error 1455 encountered

stoperp

9 积分	0 好友	3 主题

发消息

EXP-00008: ORACLE error 1455 encountered

1^#

发表于 2012-2-17 13:28:03 | 查看: 6709| 回复: 1

操作系统： linux 5
数据库版本： oracle 10204 RAC
exp 导出某用户时，部分表导出失败经常报错，而且每次报错的表有不相同的
以下为报错信息：
. . exporting table          L2_DW_SSB_QYNJGLQK    3634 rows exported
. . exporting table          L2_DW_SSB_QYNJQYGLGM
EXP-00008: ORACLE error 1455 encountered
ORA-01455: converting column overflows integer datatype
. . exporting table          L2_DW_SSB_QYNJZHGLGM
EXP-00008: ORACLE error 1455 encountered
ORA-01455: converting column overflows integer datatype
. . exporting table       L2_DW_SSB_QYNJZHGLGM_ZH       23 rows exported
. . exporting table          L2_DW_SSB_QYTZZCGM    246260 rows exported
. . exporting table          L2_DW_SSB_QYTZZCGMFX    121095 rows exported
. . exporting table    L2_DW_SSB_QYTZZCGMFX_MID1    121095 rows exported
. . exporting table    L2_DW_SSB_QYTZZCGMFX_MID2 1368166 rows exported
. . exporting table          L2_DW_SSB_QYTZZEZB    534825 rows exported
. . exporting table             L2_DW_SSB_QYZEZB
EXP-00008: ORACLE error 1455 encountered
ORA-01455: converting column overflows integer datatype
. . exporting table          L2_DW_SSB_QYZHTZRJ    47541 rows exported
. . exporting table                L2_DW_SSB_SJTQ       0 rows exported

分享0

收藏0 回复只看该作者道具举报

Maclean Liu(刘相兵

2^#

发表于 2012-2-17 15:14:01

Error:  ORA 1455
Text: converting column overflows integer datatype
-------------------------------------------------------------------------------
Cause:  The converted form of the specified expression was too large for the
      specified datatype.
Action: Define a larger datatype or correct the data.

做一个 exp的 10046 level 12 trace发上来

回复只看该作者道具举报

返回列表

		自动登录	找回密码
密码			注册