Skip to Main Content

Database Software

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!

How to fix this error: IMP-00003: ORACLE error 1435 encountered

958907Aug 29 2012 — edited Sep 5 2012
Hello,

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.

=============================================================
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 3 2012
Added on Aug 29 2012
10 comments
20,617 views