Re: Import Problems with Oracle 8i - please help..Backup/restore or export/ import ???
From: Frank <fvanbortel_at_netscape.net>
Date: Tue, 11 Mar 2003 21:45:29 +0100
Message-ID: <3E6E4AE9.10406_at_netscape.net>
>
Date: Tue, 11 Mar 2003 21:45:29 +0100
Message-ID: <3E6E4AE9.10406_at_netscape.net>
Subrahmanyam Arya wrote:
> 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
>
Yes - only a full export as system would have created these
when imported fully. Otherwise, you must:
- create the user
- grant SYS object priveleges
Search archives and/or the web; this is a faq situation, and there are scripts to resolve the grants stuff.
-- Regards, Frank van BortelReceived on Tue Mar 11 2003 - 21:45:29 CET