Tuesday, December 4, 2012

Oracle imp/exp blues...

What a day. Syntax is everything. A file path, that's all that was missing. So, next time you are importing and Oracle .dmp file (the old style, not the newer dp style) here is the simple syntax:


imp SYSTEM/password@orcl file=C:\WhereEverYouPutIt\file.dmp full=y log=imp.log
 This did it. It seems that the Oracle imp command does not look in the default DMPDP folder like impdp does.

Jeremiah

No comments: