Re: Import a dmp file

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
> post.
>
> 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
> systems.
>
> 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
> neede

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 ...

best regards,
Markus Tazl

--
Markus Tazl