我用exp导出的文件,在通过imp导入到库中时出错,请帮忙看下这样的错误信息该如何处理. . importing table "CUSTOMER" 3 rows imported
IMP-00032: SQL statement exceeded buffer length
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file:
PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "TS_MDSP_DATA" LOGGING NOCOMPRESS, PARTITION "MDSP_CDR_PARTITION_2910" VALUES LESS THAN ('20291101000000') PCTFREE 10 PCTUSED 40 INIT...
. . importing table "MDSP_PRODTRY" 0 rows imported
IMP-00032: SQL statement exceeded buffer length
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file:
PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "TS_MDSP_DATA" LOGGING NOCOMPRESS, PARTITION "MDSP_CDR_PARTITION_2910" VALUES LESS THAN ('20291101000000') PCTFREE 10 PCTUSED 40 INIT...
. . importing table "MDSP_PRODTRY" 0 rows imported
楼主在imp时有写buffer吗? 把buffer 设大点看看imp user/pwd file=.. buffer=1024000
增大可以解决,不清楚如果不加buffer项,默认是多少
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:
这些错误。