-
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 ?? !!!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|