ORA-01435: user does not exist when using imp utility
436307Jan 28 2005 — edited Jan 29 2005I 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