报错日志如下:
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export file created by EXPORT:V10.02.01 via conventional path
import done in UTF8 character set and UTF8 NCHAR character set
. importing SHOW's objects into SHOW
. . importing table "TD_SUPPLIER_COMPETITION" 0 rows imported
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT SELECT ON "TD_SUPPLIER_COMPETITION" TO "HGGJV2READ""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'HGGJV2READ' does not exist
. . importing table "TD_PV_PC_STATUS" 1 rows imported
. . importing table "TD_PRODLINE" 4116 rows imported
. . importing table "TD_CATE_PUB" 6435 rows imported
. . importing table "TD_CATE_DISP" 4679 rows imported
. . importing table "TD_CATALOG" 8485 rows imported
. . importing table "TC_COUNTRY" 221 rows imported
. . importing table "REP_SUPPLIER_AREA_LIST" 518 rows imported
. . importing table "REP_SUPPLIER_AREA" 84662 rows imported
IMP-00032: SQL statement exceeded buffer length
IMP-00032: SQL statement exceeded buffer length
IMP-00032: SQL statement exceeded buffer length
IMP-00032: SQL statement exceeded buffer length
"GRANT SELECT ON "REP_KEYWORD_WEEK_HOT" TO "HGGJV2READ""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'HGGJV2READ' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT UPDATE ON "REP_KEYWORD_WEEK_HOT" TO "HGGJV2READ""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'HGGJV2READ' does not exist
IMP-00032: SQL statement exceeded buffer length
IMP-00032: SQL statement exceeded buffer length
IMP-00032: SQL statement exceeded buffer length
IMP-00032: SQL statement exceeded buffer length
IMP-00032: SQL statement exceeded buffer length
IMP-00032: SQL statement exceeded buffer length
IMP-00032: SQL statement exceeded buffer length
IMP-00032: SQL statement exceeded buffer length
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file:
IMP-00008: unrecognized statement in the export file:
IMP-00008: unrecognized statement in the export file:
IMP-00008: unrecognized statement in the export file:
.
.
.
.
首先解了决用户对象问题,创建HGGJV2READ用户,一下错误解决:
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'HGGJV2READ' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT UPDATE ON "REP_KEYWORD_WEEK_HOT" TO "HGGJV2READ""
对于
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file:
网上说版本引起,也有的说导出文件或者数据库中存在坏块,后来搜多到一篇文章,在导入时候加个buffer参数,经测试问题解决,但不明原因:
imp file=95tab.dmp fromuser=show touser=show buffer=20480000 log=show.log
阅读(3772) | 评论(0) | 转发(0) |