Hello,

Since one week, i try to import a database. This DB is located on a server which contains

the Oracle 8.1.5 Version on WINDOWS NT 4. My computer contains the 8.1.5 and 8.1.7 Versions

and is installed with WINDOWS 2000 Professionnal OS.

When i launch the exp procedure, all is good. It terminate successfully. (i use the 8.1.5

exp utility). This is my parameters file which is launch by this command line :
------------------------------------------------------
c:\oracle\ora815\bin\exp user/pwd@test parfile=EXP.par
------------------------------------------------------

FILE PARAMETER :
---------------------
FILE=EXP_DATAFILE.DMP
LOG=EXPFILE.LOG
FULL=Y
INCTYPE = COMPLETE
STATISTICS = NONE
---------------------

One datafile "EXP_DATAFILE" is created.

But when i execute the comand line :
----------------------------------------------------------------
c:\oracle\ora815\bin\imp user/pwd@local PARFILE = imp.PAR
----------------------------------------------------------------

Which uses this parameters file :

FILE PARAMETER :
------------------------
FILE=EXP_DATAFILE.DMP
LOG=IMPFILE.LOG
FROMUSER=MANAGER
TOUSER=MANAGER
IGNORE=Y
ANALYZE=N
RECALCULATE_STATISTICS=N
SHOW=N
ROWS=Y
------------------------

, an error occurs.


See the log file generated by the imp procedure :

------------------------------------------------------------------------------
Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
JServer Release 8.1.7.0.0 - Production

Export file created by EXPORT:V08.01.05 via conventional path

Warning: the objects were exported by SYSTEM, not by you

import done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character set
. . importing table "ADDRESSES" 1973 rows imported
. . importing table "ASSIGNMENT" 79442 rows imported
IMP-00017: following statement failed with ORACLE error 3113:
"CREATE INDEX "ASSIGNMENT_I_01" ON "ASSIGNMENT" ("CPID" , "CUSTOMERID" ) PC"
"TFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 9625600 NEXT 106496 MINEXT"
"ENTS 1 MAXEXTENTS 121 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_PO"
"OL DEFAULT) TABLESPACE "GMS_TABLESPACE" LOGGING"
IMP-00003: ORACLE error 3113 encountered
ORA-03113: end-of-file on communication channel
IMP-00021: operating system error - error code (dec 2, hex 0x2)
IMP-00000: Import terminated unsuccessfully

IMP-00021: operating system error - error code (dec 2, hex 0x2)
------------------------------------------------------------------------------

NB : tablespaces and the user used to import datafile are the same that tablespaces and

users employed in source database (type, name, size, characteristics, ... )


Can you explain me why this error occurs or how can i resolve it ?? !!!