Re: Import a dmp file
Date: Wed, 23 Jan 2008 11:37:39 -0800 (PST)
On 23 Jan., 20:17, Curious Joe <joebob.john..._at_gmail.com> wrote:
> I am less than a novice on Oracle so I am sorry for such a simple
> A client has given me dmp files of their data. I have installed
> Oracle 11g to import the dmp files so I can then transfer them to my
> I am able to log in to sqlplus etc and the IMP command works except
> that I am getting an error:
> "ALTER SESSION SET CURRENT_SCHEMA= "SYSADM""
> IMP-00003: ORACLE error 1435 encountered
> ORA-01435: user does not exist
> IMP-00000: Import terminated unsuccessfully
> Can anyone help me with this? I can "list" the contents etc if
I'm afraid there might be several reasons ;-( As David said, missing
tablespaces (beside other reasons)
might cause some trouble ...
Maybe you could post the content of your import.log ? Chances are that
this might help to find a way to
solve your problem ...
-- Markus TazlReceived on Wed Jan 23 2008 - 13:37:39 CST