Re: Full Export / Import headache

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.
Received on Thu Sep 18 2003 - 17:26:27 CDT