error while taking an EXPORT of a TABLE.......URGENT
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: error while taking an EXPORT of a TABLE.......URGENT

  1. #1
    Join Date
    Mar 2003
    Location
    India
    Posts
    1

    Exclamation error while taking an EXPORT of a TABLE.......URGENT

    Hi,

    I am working on oracle 8.0.0.5. I am sending the details of the TABLE on which EXPORT was done. I am confused that has the export been successfully committed or it has ended with errors.

    What is the solution for it ?

    The export has been taken by a utility named SAPDBA.

    Thanks in advance....



    Export: Release 8.0.5.2.1 - Production on Tue Apr 1 17:3:35 2003

    (c) Copyright 1998 Oracle Corporation. All rights reserved.

    Connected to: Oracle8 Enterprise Edition Release 8.0.5.2.1 - Production
    PL/SQL Release 8.0.5.2.0 - Production
    Export done in US7ASCII character set and US7ASCII NCHAR character set
    Note: constraints on tables will not be exported

    About to export specified tables via Direct Path ...
    Current user changed to SAPR3
    . . exporting table TST03 96930 rows exported
    Export terminated successfully without warnings.
    :::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

    SAPDBA: Export to '/oracle/ARV/sapdata30/exp_tst03/0304011652/expBTABD.dmp.'
    successfully completed.
    :::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
    SAPDBA: The following export dump files have been created:

    /oracle/ARV/sapdata30/exp_tst03/0304011652/expBTABD.dmp.
    :::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
    SAPDBA: Running shell scripts
    '/oracle/ARV/sapreorg/0304011652/imxBTABD.sh'
    and 'imcBTABD.sh'
    2003-04-01 17.36.40

    Import: Release 8.0.5.2.1 - Production on Tue Apr 1 17:36:40 2003

    (c) Copyright 1998 Oracle Corporation. All rights reserved.

    Connected to: Oracle8 Enterprise Edition Release 8.0.5.2.1 - Production
    PL/SQL Release 8.0.5.2.0 - Production

    Export file created by EXPORT:V08.00.05 via direct path
    . . skipping table "TST03"

    IMP-00009: abnormal end of export file

    Import terminated successfully with warnings.
    :::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
    SAPDBA: Please check the import messages in the log file carefully!
    Warnings and errors will be ignored if you continue.

  2. #2
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865

    Re: error while taking an EXPORT of a TABLE.......URGENT

    Originally posted by rohit_n26
    Export terminated successfully without warnings.
    ...

    Export file created by EXPORT:V08.00.05 via direct path
    . . skipping table "TST03"

    IMP-00009: abnormal end of export file

    It looks like your export was successful but import is not... could be an physical disk I/O error...

    BTW, you can retry the operation and see if it occurs again...

    IMP-00009: abnormal end of export file
    Cause: The export file is probably from an aborted Export session.

    Action: If so, retry the export and import. Otherwise, report this as an Import bug and submit the export file that caused this error to customer support.
    http://download-east.oracle.com/docs...ch6b1.htm#7329
    HTH.

  3. #3
    Join Date
    May 2001
    Posts
    736
    Check the log file created by the import operation it will lead u to the error.

  4. #4
    Join Date
    Aug 2002
    Location
    Bangalore, India
    Posts
    405
    It looks like your dumpfile got corrupted.
    ftp in bin mode???!!!
    -nagarjuna

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