Re: Need help importing

Hello,

Are you sure that no user SQL exists in your database (i mean the users you want to create) ?

You know the option IGNORE=Y : it means that if the object exists, oracle does not show the error.

Have you try in the command line :
* imp sys/xx file=yourFile log=import full=y ignore=y commit=y buffer=128000
* imp sys/xx file=yourFile log=import fromuser=original touser=destination ignore=y commit=y buffer=128000
(before to import you have to create the user destination and all the tablespaces, roles needed)

Good luck

"Mark Grover" <mark.grover_at_seaquistperfect.com> a écrit dans le message news: 3a4261e9$0$150_at_wodc7nh6.news.uu.net...
> I'm trying to import a full database into version 8i that
> was exported from version 8.0.
>
> During the import, as it tries to "ALTER SCHEMA" (and other things),
> I keep getting "ORA-01435: user does not exist" errors
> Of course they don't exist yet - they're suppose to be imported!
>
> I'm importing as user sys and using a params file with the following:
> FULL=Y
> GRANTS=Y
> INDEXES=Y
>
>
> What am I doing wrong?
> (When I exported earlier, I used FULL=Y)
>
>
Received on Thu Dec 21 2000 - 16:10:42 CST