Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

IMP-00032: SQL statement exceeded buffer length IMP-00008: unrecognized sta

Harsh_vMay 7 2012 — edited May 8 2012

Hi,

I have found this error at the time of import.
Even
1) my export and dump file absolutely fine. and
2) Buffer cache have enough size.

But i was doing import i was found this error. please help

$ cat full_exp.log

Import: Release 10.2.0.1.0 - Production on Mon May 7 19:54:20 2012

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

Export file created by EXPORT:V10.02.01 via conventional path
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses WE8ISO8859P1 character set (possible charset conversion)
. importing EBU's objects into EBU
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:
*1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "TS1" LOGGING NOCOMPRESS, PARTITION "P_APP_912" VALUES LESS THAN (912) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE...*
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:
LESS THAN (870) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "TS2" LOGGING NOCOMPRESS, PARTITION "P_APP_WITH_MSG_871" VALUES LESS THAN (871) PCTFREE 10 PCTUSED 40 INI...

Import terminated successfully with warnings.