Archive April 2012

exit imp prompt (IMP-0002 error)

You are trying to import oracle dump file with imp command, but imp don’t have access to that dump file. You will be prompted to enter a new dump file path name.

IMP-00002: failed to open expdat.dmp for read
Import file: expdat.dmp >

>> use CTRL-D to exit imp prompt

import oracle dump file

import dump file
>> imp witr/passwd@WITRDBIDENT file=/tmp/expdat.dmp fromuser=witr touser=witr log =/tmp/imp.log

import one table from dump file
>> imp witr/passwd@WITRDBIDENT file=/tmp/expdat.dmp fromuser=witr touser=witr tables=T_WITR log =/tmp/imp.log