-
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 ?? !!!
-
Are you trying to import 8.1.5 to 8.1.7 on such case, I would suggest that you use 8.1.5's imp. One other thing and to increase your swap space and see whether it goes through.
Sam
-
Thanks but i've already tried to use both 8.1.5 utilities. But it doesn't work.
Another solution ? !!!!!
-
Did you increase your swap sapce and try?
Sam
-
Yes, of course.
I've already changed many parameters : SGA allocated, Tablespaces' size, blocks' size...
Nothing change the situation.
But I've noticed that if I use 817 utilities, the imp-00021 error doesn't appear. But the imp procedure stops at the same moment...
Thanks for your responses :-)))))
-
Maybe some type of corruption in your export file. Try exporting the data again.
-
I already try to export data many times.
I try to launch exp procedure from server and from my computer.
I obtain the same result...
-
Just some (maybe silly) ideas ...
See if trace file was generated.
Try bypass Net8: make sure 8.1.5 database is default on your computer and call imp without specifying "@local".
