While
exporting table or schema using exp/imp utility you may come across
below error.
Most
of the time this error occurs due to insufficient space available on
disk.so confirm space is available where you are taking taking
export dump and re-run export.
[oracle@DEV
admin]$ exp test/test@DEV tables=t1,t2,t3,t4 file=exp_tables.dmp
log=exp_tables.log
Export:
Release 9.2.0.8.0 - Production on Thu Sep 10 12:25:52 2015
Copyright
(c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected
to: Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production
With
the Partitioning, OLAP and Oracle Data Mining options
JServer
Release 9.2.0.8.0 - Production
Export
done in US7ASCII character set and AL16UTF16 NCHAR character set
About
to export specified tables via Conventional Path ...
.
. exporting table t1 1270880 rows exported
.
. exporting table t2 2248883 rows exported
.
. exporting table t3 2864492 rows exported
.
. exporting table t4
EXP-00002:
error in writing to export file
EXP-00002:
error in writing to export file
EXP-00000:
Export terminated unsuccessfully
I
hope this article helped you. Your
suggestions/feedbacks are most welcome.
Keep learning... Have a great day!!!
Keep learning... Have a great day!!!
thank you it is very help full
ReplyDelete