-
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.
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
|