Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Full Export / Import headache
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 - 12:25:22 CDT