Monday, 29 April 2013

imdp not recognized as internal or external Command | Error in importing dump oracle

imdp not recognized as internal or external Command | Oracle Error


When We try to import an oracle dump file we may get this error , The most probably the reason  for such error is simple. 

Consider the following command,
" <sql> impdp username/password dumpfile=dump_file.dmp log=impdpas.log schemas=schema_name "

When You execute that command, you will get the following error


'imdp' is not recognized as an internal or external command,
operable program or batch file.

Solution is that you are not supposed to execute the command in "SQL"command prompt.
You Should exit SQL command prompt and execute that in Normal CMD (windows command Prompt)

C:\Windows\system32>  impdp username/password dumpfile=dump_file.dmp log=impdpas.log schemas=schema_name

Hope This will help you to resolve your issue.

Subscribe to me for more updates :)

No comments:

Post a Comment