Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01435: user does not exist when using imp utility

436307Jan 28 2005 — edited Jan 29 2005
I installed Oracle 8.1.7.0.0 successfully on WINDOWS 2000 and created a database TEST using DBCA. Then I used a script to creat a tablespace and a user in TEST databse. I could use the imp utility to import the data (a dmp file) to the TEST database without any problem. But after I applied a patch to bring up the version to Oracle 8.1.7.4.1, I got the following error when I tried to use the imp utility again to import the data (a dmp file) to the TEST database.

IMP-00003: ORACLE error 1435 encountered
ORA-01435: user does not exist
IMP-00000: Import terminated unsuccessfully

I checked that I created the same user test (as it is in dmp file I wanted to import) on TEST, and I could login to TEST using:

sqlplus test/test@TEST

The command I used is:

imp system/password@TEST file=test.dmp full=y log=importTEST.TEST.tmp

I also tried to use the following command:
imp system/password@TEST file=test.dmp fromuser=test touser=test log=importTEST.TEST.tmp

and got the same error as before.

Anyone has any clues what could go wrong? The only difference for me to import the data on TEST is that the
previous successful import was done in Oracle 8.1.7.0.0.
Is it possible that I missed something during the applying of the patch 8.1.7.4.1?

Thanks, and your help is greatly appreciated.

Jane
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 26 2005
Added on Jan 28 2005
3 comments
654 views