-
Hi All,
OS: Windows NT.
Version: 8.1.5
I was trying to export a oracle8.1.5 database and got the following error message:
Connected to: Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production
With the Partitioning and Java options
PL/SQL Release 8.1.5.0.0 - Production
Export done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character set
About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user PANDAOWNER
. exporting object type definitions for user PANDAOWNER
About to export PANDAOWNER's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export PANDAOWNER's tables via Conventional Path ...
. . exporting table A000_TBL 1 rows exported
. . exporting table A015_FORMS_TBL 0 rows exported
. . exporting table A015_RECEIPTS_TBL 20 rows exported
. . exporting table 015_REP_TBL 0 rows exported
. . exporting table A015_RTO_TBL 10 rows exported
. . exporting table A015_SORT_TBL 103 rows exported
. . exporting table A015_SUGS_TBL 0 rows exported
. . exporting table A025_REP_TBL 1 rows exported
. . exporting table A028_9_INT_TBL 0 rows exported
. . exporting table A028_SPD_TBL 0 rows exported
. . exporting table A029_A225_STOCKFIGSME_TBL 0 rows exported
. . exporting table A029_ACCEPT_TBL 0 rows exported
. . exporting table A029_DSB_EXT_TBL 0 rows exported
. . exporting table A029_LOG_TBL
EXP-00056: ORACLE error 3113 encountered
ORA-03113: end-of-file on communication channel
EXP-00222:
System error message 2
System error message: No such file or directory
EXP-00008: ORACLE error 3114 encountered
ORA-03114: not connected to ORACLE
EXP-00222:
System error message 2
System error message: No such file or directory
EXP-00000: Export terminated unsuccessfully
EXP-00222:
System error message 2
System error message: No such file or directory
Any help will be appreciated.
Thanks.
Vijay.
Say No To Plastics
-
Hi Vijay
Off hand I can say that you have lost connection to the database . The error "end-of-file on communication channel "
suggests so also check if the directory and file where you exporting exists "No such file or directory " error suggests so.
Rather you could post the export parfile as well . We can help
Cheers
Afshin
-
Hi,
This was the command that I used:
exp userid=uid/pwd file=exp.dmp log=exp.log.
Thanks.
Vijay.
Say No To Plastics
-
Hi
Can you just give a path for example
like this and get back if it is working .
exp userid=uid/pwd file=c:\exp.dmp log=c:\exp.log.
Thanks.
Afshn
-
Hi,
I tried like that. Still it behaves the same. Even in the previous methods the dumpfile was created in C drive only.
Thanks.
Vijay.
Say No To Plastics
-
Hi
Weird it worked at my end . R u sure you are still connected ( thru sqlplus ) to the DB while the export is happening.
Do you receive an error message there I am worried about the "end of communication " error . It usually signifies when client loses connection with the server .
Please let us know so that we can help
Cheers
Afshin
-
Hi,
try this:
exp userid/pwd@servicename file=c:\exp.dmp log=c:\exp.log
that should work if your Database is ok
-
Error in Export
The error show that you gets disconnected while you are taking the export backup. Please check whether the instance was up or not when you encounter that error during export.
Thanks,
Suvendu
Suvendu Das
Cognizant Technologies Solution
Phone : 357-3211/3212/3213 ext. 1443/1446
-
check note 100405.1 on metalink.
Export may corrupt export file without any wanings if the object being exported was previously imported into the database.
Only affects 8.1.5, fixed in 8.1.6 and upwards.
Contact Oracle.
Once you have eliminated all of the impossible,
whatever remains however improbable,
must be true.
-
Guys, I need your help to overcome this.
Thanks.
Vijay.
Say No To Plastics
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
|