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 anORA-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
Then after the import you can gather statistics as needed.