Wednesday, April 13, 2011

path oracle 10g

Problem:
You can't execute commands such as "imp", "exp", "impdp" or "expdp" even though the path is setted in the environment variable.

Solution:
In my case, there was a mistake. When I installed Oracle 10g, the path was automatically set to :
PATH=C:\oraclexe\app\oracle\product\10.2.0\server\bin;C:\Windows\system32...

But in reality it should be "BIN" (uppercase)!
PATH=C:\oraclexe\app\oracle\product\10.2.0\server\BIN;C:\Windows\system32...

After modifying the path, I could execute the command "impdp" anywhere from the command line.

No comments: