couldn't figure out the error in exp [message #331003] |
Wed, 02 July 2008 02:11 |
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 #331057 is a reply to message #331022] |
Wed, 02 July 2008 04:24 |
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.
|
|
|
|