日志如下:
E:\>imp shop/shopImport: Release 10.1.0.2.0 - Production on 星期日 10月 28 20:45:18 2012Copyright (c) 1982, 2004, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Pro
tion
With the Partitioning, OLAP and Data Mining optionsImport file: EXPDAT.DMP > 20121028.dmpEnter insert buffer size (minimum is 8192) 30720>Export file created by EXPORT:V10.01.00 via conventional pathWarning: the objects were exported by RCB_ORDERS, not by youimport done in ZHS16GBK character set and AL16UTF16 NCHAR character set
List contents of import file only (yes/no): no >Ignore create error due to object existence (yes/no): no > yesImport grants (yes/no): yes > noImport table data (yes/no): yes >Import entire export file (yes/no): no >
Username: rcb_ordersEnter table(T) or partition(T:P) names. Null list means all tables for user
Enter table(T) or partition(T:P) name or . if done: CRED_PRODUCTINFO20110522Enter table(T) or partition(T:P) name or . if done:. importing RCB_ORDERS's objects into SHOP
. . importing table "CRED_PRODUCTINFO20110522"
IMP-00058: ORACLE error 1438 encountered
ORA-01438: value larger than specified precision allows for this column
Import terminated successfully with warnings.测试服务器的数据库软件版本和生产环境完全一致,但有两张表无法导入。
E:\>imp shop/shopImport: Release 10.1.0.2.0 - Production on 星期日 10月 28 20:45:18 2012Copyright (c) 1982, 2004, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Pro
tion
With the Partitioning, OLAP and Data Mining optionsImport file: EXPDAT.DMP > 20121028.dmpEnter insert buffer size (minimum is 8192) 30720>Export file created by EXPORT:V10.01.00 via conventional pathWarning: the objects were exported by RCB_ORDERS, not by youimport done in ZHS16GBK character set and AL16UTF16 NCHAR character set
List contents of import file only (yes/no): no >Ignore create error due to object existence (yes/no): no > yesImport grants (yes/no): yes > noImport table data (yes/no): yes >Import entire export file (yes/no): no >
Username: rcb_ordersEnter table(T) or partition(T:P) names. Null list means all tables for user
Enter table(T) or partition(T:P) name or . if done: CRED_PRODUCTINFO20110522Enter table(T) or partition(T:P) name or . if done:. importing RCB_ORDERS's objects into SHOP
. . importing table "CRED_PRODUCTINFO20110522"
IMP-00058: ORACLE error 1438 encountered
ORA-01438: value larger than specified precision allows for this column
Import terminated successfully with warnings.测试服务器的数据库软件版本和生产环境完全一致,但有两张表无法导入。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货