Re: Import Problems with Oracle 8i - please help..Backup/restore or export/ import ???

From: Subrahmanyam Arya <avsrk_at_mailcity.com>
Date: 11 Mar 2003 11:59:22 -0800
Message-ID: <25c1993e.0303111159.4a7d3265_at_posting.google.com>


Hi,

I did the same as mentioned below.I still get these errors IMP-0003: ORACLE error 1435 encountered, ORA-1435: user does not exist

I am expected to create the user on the target database ???

-thx,
avsrk

osy45 <member18536_at_dbforums.com> wrote in message news:<2628238.1047366551_at_dbforums.com>...
> why not to import only the users which are acutally not included in the
> database as you had build a new instance from scratch.
>
> exp system/manager_at_sid-SE full=y buffer=4000000 grants=y consistent=y
>
> imp system/manager_at_sid-EE file=expdat.dmp buffer=4000000
> fromuser=(usr1,usr2,usr3) touser=(usr1,usr2,usr3)
>
> then the errors should be approcimately 0
Received on Tue Mar 11 2003 - 20:59:22 CET

Original text of this message