一次exp/imp分區(qū)表遇到的問題

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:
  .

.

.

.

首先解了決用戶對象問題，創(chuàng)建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