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/
,如需转载,请注明出处,否则将追究法律责任。