Database Utilities (MOSC)

MOSC Banner

import errors

edited Mar 3, 2011 7:58AM in Database Utilities (MOSC) 4 commentsAnswered
All,

I have exported a schema successfully.  Now I am trying to import with a fromuser and touser.  Both schemas exist in the database and have for years.  I am using my dba login to do this.  Here is the error I am getting

IMP-00003: ORACLE error 1435 encountered
ORA-01435: user does not exist
Import terminated successfully with warnings.

my import syntax is:

Imp dba_login/password@instancename file=bkup_03032011.dmp log=restore_bkup_03032011.log buffer=1000000 commit = y analyze=n fromuser = abc touser= cde;

I exported without issue.  I am running this from a command line.

What am I doing wrong please?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center