This discussion is archived
11 Replies Latest reply: Jul 12, 2012 10:59 AM by jgarry Branched to a new discussion. RSS

Import Error: ORA-01435 : User does not exist

755639 Newbie
Currently Being Moderated
Hi all,

I am importing a dump into 11g Database, the dump taken from Old Financial release 6 [EBIZ]

i given this command:

IMP FILE=EXPDUMP.DMP BUFFER=524288000 FULL=Y IGNORE=Y
Import user system and password given...

Once its started and getting error

+"ALTER USER "PERFUSER" QUOTA UNLIMITED ON "OTHERD""+
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'PERFUSER' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
+"ALTER USER "DUB_QUERY" QUOTA UNLIMITED ON "OTHERD""+
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'DUB_QUERY' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
+"ALTER USER "OEMV22" QUOTA UNLIMITED ON "OEM_REPOSITORY""+
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'OEMV22' does not exist
IMP-00017: following statement failed with ORACLE error 1918:
+"ALTER USER "W03063_ITD" QUOTA UNLIMITED ON "TEMP" QUOTA UNLIMITED ON "OEM_R"+
+"EPOSITORY""+
IMP-00003: ORACLE error 1918 encountered
ORA-01918: user 'W03063_ITD' does not exist
+. importing APPS's objects into APPS+
IMP-00003: ORACLE error 1435 encountered
ORA-01435: user does not exist
+. importing DUB_QUERY's objects into DUB_QUERY+
IMP-00003: ORACLE error 1435 encountered
ORA-01435: user does not exist
+. importing SYSTEM's objects into SYSTEM+
+. importing APPLSYS's objects into APPLSYS+
+"ALTER SESSION SET CURRENT_SCHEMA= "APPLSYS""+
IMP-00003: ORACLE error 1435 encountered
ORA-01435: user does not exist
IMP-00000: Import terminated unsuccessfully

Kindly advice me what is the wrong,,

I have created all the data files same like Old Database. so while importing All the USERs will created, if its correct then why this "*ORA-01435 : User does not exist*" coming...


Regards

Paja

Edited by: Hameed on Jul 2, 2012 4:50 AM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points