The Import Utility wizard is executed to import a DMP file. This import results in some constraint violation errors. At the end of the import, the Output tab and the generated log file of the import do not show/include the " 0 rows imported. Import terminated successfully with warnings." message.
The IMP.exe file designated in Options | Executable screen is not properly set.
1. Select Tools | Options menu option
2. Select Executables from left side tree
3. For Import field, select the Browse button to navigate to the IMP.exe file of the locally installed Oracle client. (The AutoFind option may have found the IMP.exe of the installed DevSuite>
Search computer for all instances of IMP.exe file as there can be muliptiple instances of this file in case of Oracle DevSuite. A test of the IMP.exe can also be done outside of Toad via the DOS command prompt as such:
IMP <user name>/<password@<database name> FILE=<path and file name of your DMP file> LOG=<path and file name of your log file> FROMUSER=<source schema name> TOUSER=<destination user name>
