Error while exporting............
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 14

Thread: Error while exporting............

Hybrid View

  1. #1
    Join Date
    Mar 2002
    Posts
    301
    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

  2. #2
    Join Date
    May 2001
    Location
    New Zealand
    Posts
    123
    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








  3. #3
    Join Date
    Mar 2002
    Posts
    301
    Hi,

    This was the command that I used:

    exp userid=uid/pwd file=exp.dmp log=exp.log.

    Thanks.
    Vijay.
    Say No To Plastics

  4. #4
    Join Date
    May 2001
    Location
    New Zealand
    Posts
    123
    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

  5. #5
    Join Date
    Mar 2002
    Posts
    301
    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

  6. #6
    Join Date
    May 2001
    Location
    New Zealand
    Posts
    123
    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


  7. #7
    Join Date
    Jan 2002
    Posts
    152
    Hi,
    try this:
    exp userid/pwd@servicename file=c:\exp.dmp log=c:\exp.log
    that should work if your Database is ok

  8. #8
    Join Date
    Jun 2002
    Posts
    3

    Red face 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

  9. #9
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    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.

  10. #10
    Join Date
    Mar 2002
    Posts
    301

    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
  •  


Click Here to Expand Forum to Full Width