Home » RDBMS Server » Server Utilities » couldn't figure out the error in exp
couldn't figure out the error in exp [message #331003] Wed, 02 July 2008 02:11 Go to next message
sarwagya
Messages: 87
Registered: February 2008
Location: Republic of Nepal
Member
I am trying to export a table using the exp command.
exp scott/tiger@10g.company.com file=emp.dmp log=emp.log tables=emp rows=yes indexes=yes

first, I tried it from php's OS command executing statement -- exec() and got the return code as 1.
I couldn't figure out what it means. Can't I get the actual error code like exp-...

Later, when I tried it from sqlplus, it works successfully.

Please suggest me what might be the problem.

Thanks.
Re: couldn't figure out the error in exp [message #331022 is a reply to message #331003] Wed, 02 July 2008 03:02 Go to previous messageGo to next message
Michel Cadot
Messages: 64117
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You did it wrong.
What can we say more with what you posted?

Regards
Michel
Re: couldn't figure out the error in exp [message #331029 is a reply to message #331022] Wed, 02 July 2008 03:27 Go to previous messageGo to next message
sarwagya
Messages: 87
Registered: February 2008
Location: Republic of Nepal
Member
Does the return code 1 suggest anything special?
Re: couldn't figure out the error in exp [message #331057 is a reply to message #331022] Wed, 02 July 2008 04:24 Go to previous messageGo to next message
sarwagya
Messages: 87
Registered: February 2008
Location: Republic of Nepal
Member
I found out by hit and trial that the error was related to permission.

Since exp tries to create the dump file in the current working directory, and as there was no write permission in that directory,
I got the error.

Now, when I changed the directory from inside the code, it worked.

Thanks anyway.
Re: couldn't figure out the error in exp [message #331078 is a reply to message #331057] Wed, 02 July 2008 04:59 Go to previous message
Michel Cadot
Messages: 64117
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Thanks for the feedback, anyway.

Regards
Michel
Previous Topic: SQLLDR - Delimited by NEWLINE
Next Topic: SQL*Loader-704: Internal error: ... ORA-12560: TNS:protocol adapter error
Goto Forum:
  


Current Time: Tue Dec 06 02:40:22 CST 2016

Total time taken to generate the page: 0.15591 seconds