OraFAQ Forum: Server Utilities » exp command not running

Home » RDBMS Server » Server Utilities » exp command not running (oracle 10g ,redhat enterprise 5)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

exp command not running [message #419685]

Tue, 25 August 2009 02:45

sudh11482
Messages: 16
Registered: September 2007
Location: Lucknow

Junior Member

Hi all,

I am getting problem while exporting the data which is as follows:

Export done in US7ASCII character set and UTF8 NCHAR character set
EXP-00002: error in writing to export file
EXP-00000: Export terminated unsuccessfully

All the drives have sufficient spaces.However, I was taking the dump a day before but from today onwards it is not running.
Pls provide some solution, I am tensed.

Thanks in advance.

Regards,
Sudhanshu

Report message to a moderator

Re: exp command not running [message #419688 is a reply to message #419685]

Tue, 25 August 2009 03:02

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

OS or IO error not Oracle one.

Regards
Michel

Report message to a moderator

Re: exp command not running [message #419762 is a reply to message #419685]

Tue, 25 August 2009 08:42

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

00002, 00000, "error in writing to export file"
// *Cause:  Export could not write to the export file, probably because of a 
//          device error. This message is usually followed by a device message 
//          from the operating system. 
// *Action: Take appropriate action to restore the device.

Any clues in OS messages file?

Report message to a moderator

Re: exp command not running [message #419777 is a reply to message #419762]

Tue, 25 August 2009 09:57

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

>>Pls provide some solution, I am tensed.

Check your Operating System logs.

Thanks

Report message to a moderator

Previous Topic:	Is it possible to export (expdp) a table from client m/c, without using Remote desk top connection ?
Next Topic:	[Oracle 9i] EXP not initialized properly..HELP!!

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 12:51:33 CDT 2024