Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

This question already has an answer here:

I was told I can use exp to export a certain USER, then DROP the user and with the imp command I can recreate that USER with all of its tables.

  1. Is it true?
  2. How do I do it?

I already have an ADMIN user with just about all privileges (there are 204 of them if it matters).

I tried various options of exporting the USER with the ADMIN account or with the USER's account, but no matter what I do the imp command fails if I try to run it when the USER has been dropped.

Example command:

-- From CLI:
exp USERID=MYUSER/PASS@INSTANCE FILE=mydump.dmp FULL=y
-- From SQLPLUS with admin user
DROP USER MYUSER CASCADE;
-- From CLI:
imp ADMIN/PASS@INSTANCE FILE=mydump.dmp FULL=y
-- The above command will put the contents of MYUSER into the ADMIN account ...
imp ADMIN/PASS@INSTANCE FILE=mydump.dmp FROMUSER=MYUSER TOUSER=MYUSER 
-- The above command fails with  the below message:

. importing MYUSER's objects into MYUSER
IMP-00003: ORACLE error 1435 encountered
ORA-01435: user does not exist
Import terminated successfully with warnings.
share|improve this question

marked as duplicate by Mat, Paul White, dezso, RolandoMySQLDBA, StanleyJohns Aug 19 '13 at 1:28

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

    
Please also note that expdp/impdp should be used in general instead of exp/imp unless you're dealing with ancient versions. –  Mat Aug 18 '13 at 11:01
    
@Mat - you are correct, the answer in the related question does apply to my question - but it was not clear (to me) from the answer that I MUST create the user before IMP can import into it –  RonK Aug 18 '13 at 11:02
    
@Mat - thanks, I was told that expdp/impdp cannot work from a client, only from the server. And I need to run it form a client –  RonK Aug 18 '13 at 11:03
    
I don't understand your reasoning. The error tells you the user doesn't exist. If the utility could create it, don't you think it would, or at least you'd have found an option in the docs to tell it to? –  Mat Aug 18 '13 at 11:04
    
That option is exactly what I was looking for. –  RonK Aug 18 '13 at 11:27

1 Answer 1

up vote 2 down vote accepted

To answer my own question - the answer is NO - the imp command cannot create the user for me.

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.