Re: Full Export / Import headache

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Fri, 19 Sep 2003 20:05:57 +0800
Message-ID: <3F6AF125.567B@yahoo.com>

Ed wrote:
>
> 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.

Do you need migration tool ? Why not just do it manually (without unload/reload).

Install the new software and then run the appropriate upgrade scripts - its all in the migration manual

hth
connor Received on Fri Sep 19 2003 - 07:05:57 CDT