Re: Need help importing

From: Dave Haas <davehaas_at_hotmail.com>
Date: Thu, 21 Dec 2000 17:41:37 -0700
Message-ID: <91u87s$7qj$1@news3.cadvision.com>

Hi Mark.

The user does not get created during the import. The user has to already exist in the target database before objects can be created. If you have a look inside the export file (you can open it with any editor), you will see that it just has some "create table" stmts. and then a whole bunch of "insert into" stmts.

Hope that helps,

Regards,

Dave

"Mark Grover" <mark.grover_at_seaquistperfect.com> wrote in 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 - 18:41:37 CST