Re: Import a dmp file

On Jan 23, 1:17 pm, 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
> needed.
>
> Thank you,
>
> CJ

This is, apparently, a user-level dump of data and strutures, and, as such, needs the user account created before running the imp command. This means, among other things, that you'll likely get some other errors from the import process if tablespaces don't exist, if this new user has no quota on the required tablespaces (required meaning that these tables are expecting to have this particular tablespace as their 'home'), if you create this user and leave the default tablespace assignments as 'SYSTEM' and load up that tablespace with user objects not designed to reside there ...

You have an uphill battle, I'm afraid. Do not hesitate to post any additional questions here as someone may be able to further assist you.

David Fitzjarrell Received on Wed Jan 23 2008 - 13:23:49 CST