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.
Re: error while taking an EXPORT of a TABLE.......URGENT
Quote:
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...
Quote:
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.
