How to fix this error: IMP-00003: ORACLE error 1435 encountered
958907Aug 29 2012 — edited Sep 5 2012Hello,
I am new to oracle database. I am trying import a data dump file *.dmp into my test database. I am using Oracle Database 11g. I have created "datatest" to be the user and I granted all possible rights that was there. :) but still getting this error message.
Does Oracle has a GUI tool somewhere I can try or how I can fix this issue? PLEASE HELP.
Below are the actions taken:
=========================================================================
C:\app\Administrator\admin\ORCLENT1\dpdump>imp
Import: Release 11.2.0.1.0 - Production on Wed Aug 29 22:32:39 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Username: datatest
Password:
Connected to: Personal Oracle Database 11g Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Import data only (yes/no): no > no
Import file: EXPDAT.DMP > expdat.dmp
Enter insert buffer size (minimum is 8192) 30720> 8299
Export file created by EXPORT:V11.02.00 via conventional path
Warning: the objects were exported by SYSTEM, not by you
import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
import server uses AL32UTF8 character set (possible charset conversion)
List contents of import file only (yes/no): no > no
Ignore create error due to object existence (yes/no): no > no
Import grants (yes/no): yes > yes
Import table data (yes/no): yes > yes
Import entire export file (yes/no): no > yes
. importing SYSTEM's objects into DATATEST
. importing DW_OWNER's objects into DW_OWNER
IMP-00003: ORACLE error 1435 encountered
ORA-01435: user does not exist
Import terminated successfully with warnings.
=============================================================