一次exp/imp分区表遇到的问题

lizisor

报错日志如下:

 

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 show/show008@showdb51 file=95tab.dmp fromuser=show touser=show buffer=20480000 log=show.log