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!

shows 'ORA-01435: user does not exist' for the existing user

616491Jan 8 2008 — edited Jan 29 2008
Hi All,

when I am trying to import this dump into oracle 10g, I am getting following error.
I have created a talespace 'EXIM' for this already

this is my user creation command
CREATE USER EXIM PROFILE DEFAULT IDENTIFIED BY pass DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP
ACCOUNT UNLOCK;
GRANT dba to EXIM;

the user exists in the dba_users too.

E:\Eximbills>imp exim/pass file=e:\eximbills\exim.dmp fromuser=exim touser=ex
im;

Import: Release 10.1.0.2.0 - Production on Tue Jan 8 13:00:44 2008
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options

Export file created by EXPORT:V10.02.01 via conventional path
import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
export client uses ZHS16GBK character set (possible charset conversion)
export server uses UTF8 NCHAR character set (possible ncharset conversion)
IMP-00008: unrecognized statement in the export file:

. importing EXIM's objects into EXIM;
IMP-00003: ORACLE error 1435 encountered
ORA-01435: user does not exist
Import terminated successfully with warnings.

thanks in advance
soorya
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 26 2008
Added on Jan 8 2008
16 comments
9,427 views