Q
Problem solve Get help with specific problems with your technologies, process and projects.

Export error exp-00002

I am trying to export the data using Oracle's exp command, but it fails to export with the following exception:

 exp-00002: error in writing to export file
 exp-00000: Export terminated unsuccessfully.
The database is Oracle 8.1.7 on Windows NT, and I am running the exp from the windows command.

This error is telling you that the export utility can no longer write to this disk device. This can be caused by a couple of things. The disk device could be full. Or the dump file could exceed a 2 GB file size limit. I've also seen this happen when people try to export to a network attached (mapped) drive and the network connection is not stable enough.

For More Information


This was last published in April 2003

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close