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


Dig Deeper on Oracle database design and architecture

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close