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>


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 Bortel
Received on Tue Mar 11 2003 - 21:45:29 CET

Original text of this message