4 Replies Latest reply: May 7, 2012 11:35 PM by Harsh_v RSS

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

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