Re: Full Export / Import headache

From: Tanel Poder <change_to_my_first_name_at_integrid.info>
Date: Thu, 18 Sep 2003 23:33:43 +0300
Message-ID: <3f6a16a8$1_1@news.estpak.ee>

Possibly some triggers also, if tables have them.

Tanel.

"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 - 15:33:43 CDT