Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Need help importing
Hello,
You try an import full, but have you done an export full (exp sys/xx file=database log=database full=Y direct=Y )?
Have you the log of the export ?
Regards
"Dave Haas" <davehaas_at_hotmail.com> a écrit dans le message news:
91u87s$7qj$1_at_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 Fri Dec 22 2000 - 05:20:48 CST