Oracle 9i import error IMP-00017: following statement failed with ORACLE error 3113 I try to import a schema in my database 9i of copy which is a clone of the original from where I made the export 9i also and when trying to import the schema after many hours gives the following error:


  IMP-00017: following statement failed with ORACLE error 3113:
   "DECLARE  SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := 'C20537'; SREC.MAXVA"
   "L := 'C23524'; SREC.EAVS := 0; SREC.CHVALS := NULL; SREC.NOVALS := DBMS_STA"
   "TS.NUMARRAY(454,455,....
  
  IMP-00003: ORACLE error 3113 encountered
  ORA-03113: end-of-file on communication channel
  IMP-00000: Import terminated unsuccessfully


The exp command is:

exp system/nnnnn CONSISTENT=y OWNER=myschema FILE=/path/backup_schema.dmp log=/path/backup_schema.log BUFFER=30720


The imp command is:

imp system/nnnn FROMUSER=myschema TOUSER=myschema FILE=/ path/backup_schema.dmp LOG=/path/backup_schema.log BUFFER = 536870912


I have searched and can not find a solution to this problem.
ORA-03113 is a generic error encountered when your database server process was terminated with a critical error. You can find more details in the database alert log. I guess you will see an ORA-07445 error there.

As we do not know these details, all I see is that your error is related to importing statistics. I would try to run this import without importing statistics by specifying STATISTICS=none.

STATISTICS


  
  NONE
  
  
  Do not import or recalculate the database optimizer statistics.


Then after the import you can gather statistics as needed.