Re: Full Export / Import headache

ed_zep_at_ntlworld.com (Ed) wrote in message news:<58e9f9da.0309181426.1e38401a_at_posting.google.com>...
> Thanks for the response but it's a blank database I'm importing to. As
> soon as it imports the first table with a parent key table I get the
> error.
>
> If I do a full export with constraints, then import all the data but
> with constraints=n and then do another import with just the
> constraints, would that work?
>
> Thanks.
>
> Ed.
>
>
> "F. F" <feradov_at_access4less.net> wrote in message news:<vmjqk4cmb2c576_at_corp.supernews.com>...
> > If you import data to existing tables, the order of import could generate
> > referential errors.
> > You have to disable table referential constraints before the import and
> > enable it again after
> > the import.
> >
> > "Ed" <ed_zep_at_ntlworld.com> wrote in message
> > news:58e9f9da.0309180653.504751cf_at_posting.google.com...
> > > Hi.
> > >
> > > We'd like to use the exp/imp method of upgrading our databases from
> > > 8.1.7.4 to 9.2.0.4. I don't think we trust the migration utilities
> > > here! Apparently, in the past there were problems with it.
> > >
> > > Anyway, having done a full export, I try to bring in the full import.
> > > However, as we have several schema owners, I'm getting a lot of
> > > ORA-2291 parent key not found errors.
> > >
> > > What's the best way of successfully doing this?
> > >
> > > Many thanks.
> > >
> > > Ed.

Try importing with rows=y constraints =n indexes=n the firsttime around and the second time import rows=n constraints=y indexes=y ignore=y

Michael Tubuo Ngong... Received on Fri Sep 19 2003 - 07:45:15 CDT