Google

Tuesday, October 28, 2008

change tomcat port integrated in eclipse

By changing the tomcat port (8080) in tomcat/conf/server.xml will not affect if we start the server form eclipse IDE.

So need to change the port in server.xml which is in the workspace\Servers\Tomcat vx.x Server at localhost-config\. Ths can be edit from the eclipse IDE, in the project called "Servers"

Sunday, October 26, 2008

Oracle impdp/ expdp

When I try to export a table in Oracle database using the following command,
expdp hr/hr DIRECTORY=exp_dir DUMPFILE=tables_exp.dmp TABLES=employees

I got the following error
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-39087: directory name exp_dir is invalid


You need to create a directory by loging to sqlplus from ad hr
for windows...
create directory exp_dir as 'D:directory';

then exit from sqlplus and issue the previous command