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!

Got Error during import in oracle : IMP-00003: ORACLE error 1435 encountered ORA-01435: user doe

2616394Feb 20 2014 — edited Feb 21 2014

I got this error during importing. Here i importing only two tables. we already created that user name and having permission for importing.. How can fix this issue.

imp samuser/pass123@sample file='D:\Dump\NeftTables1.dmp' ignore=y fromuser=PAYMGRPH2 touser=PAYMGRPH2;

Import: Release 10.2.0.1.0 - Production on Thu Feb 20 12:17:04 2014

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.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
. importing PAYMGRPH2's objects into PAYMGRPH2;
"ALTER SESSION SET CURRENT_SCHEMA= "PAYMGRPH2;""
IMP-00003: ORACLE error 1435 encountered
ORA-01435: user does not exist
IMP-00000: Import terminated unsuccessfully

C:\Documents and Settings\Administrator>

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 21 2014

Added on Feb 20 2014

#database-key-features, #export-import-sql-loader-external-tables

8 comments

2,797 views