Oracle 9i import error IMP-00017: following statement failed with ORACLE error 3113

errorsimportoracle

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.

Best Answer

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.