ITPub博客

首页 > Linux操作系统 > Linux操作系统 > exp导出错误 exp-00008

exp导出错误 exp-00008

原创 Linux操作系统 作者:BTxigua 时间:2010-04-28 01:41:17 0 删除 编辑
os: aix 5307
db:10204 rac

oracle环境变量设置,导出为本机导出
export NLS_LANG=american_america.zhs16gbk

1、按用户模式导出报错
exp userid=\'/ as sysdba\' WNER=DM FILESIZE=4096M FILE_FORMAT=DM_%s.dmp DIRECT=Y BUFFER=1024000
. . exporting table                NEW_DISCNT_USER
EXP-00008: ORACLE error 1455 encountered
ORA-01455: converting column overflows integer datatype
. . exporting table               NEW_PRODUCT_USER
EXP-00008: ORACLE error 1455 encountered
ORA-01455: converting column overflows integer datatype

2、单表导出的时候不报错。
BIdb1:/oracle>exp userid=\'/ as sysdba\' TABLES=DM.NEW_PRODUCT_USER FILE=DM.NEW_PRODUCT_USER.dmp DIRECT=Y BUFFER=1024000 INDEXES=N

Export: Release 10.2.0.4.0 - /Production on Tue Apr 27 19:02:29 2010

Copyright (c) 1982, 2007, Oracle.  All rights reserved.


Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining Scoring Engine
and Real Application Testing options
Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set
Note: indexes on tables will not be exported

About to export specified tables via Direct Path ...
Current user changed to DM
. . exporting table               NEW_PRODUCT_USER    1405130 rows exported
Export terminated successfully without warnings.

BIdb1:/oracle>exp userid=\'/ as sysdba\' TABLES=DM.NEW_DISCNT_USER FILE=DM.NEW_DISCNT_USER.dmp DIRECT=Y BUFFER=1024000 INDEXES=N

Export: Release 10.2.0.4.0 - Production on Tue Apr 27 19:11:56 2010

Copyright (c) 1982, 2007, Oracle.  All rights reserved.


Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining Scoring Engine
and Real Application Testing options
Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set
Note: indexes on tables will not be exported

About to export specified tables via Direct Path ...
Current user changed to DM
. . exporting table                NEW_DISCNT_USER    1704760 rows exported
Export terminated successfully without warnings.

BIdb1:/oracle>exp userid=\'/ as sysdba\' TABLES=DM.NEW_PRODUCT_USER FILE=DM.NEW_PRODUCT_USER.dmp BUFFER=1024000 INDEXES=N

Export: Release 10.2.0.4.0 - Production on Tue Apr 27 19:03:00 2010

Copyright (c) 1982, 2007, Oracle.  All rights reserved.


Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining Scoring Engine
and Real Application Testing options
Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set
Note: indexes on tables will not be exported

About to export specified tables via Conventional Path ...
Current user changed to DM
. . exporting table               NEW_PRODUCT_USER    1405130 rows exported
Export terminated successfully without warnings.

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/10867315/viewspace-660942/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2008-01-31

  • 博文量
    101
  • 访问量
    313449