Re: Migrate to 8.05!

From: Karel Novotny <knovotny_at_per4mance.cz>
Date: Thu, 14 Jan 1999 07:47:27 GMT
Message-ID: <369DA10F.9D2BC3ED@per4mance.cz>

There is another method to migrate - it is hard but it is clear - I used it: 1) full export
2) import all users from export file except SYS (imp parameters - FROMUSER TOUSER)
This method combines advantages -
You doesn't need to upgrade SYS catalogs after import and also you will get reduced extents of imported objects.
Of course, pre-requisite is that you did not use SYS schema for any user's objects.

Karel Novotny

Yeung Man wrote:

> Hi,
>
> Our company want to migrate the database from 7.3.2.3 to 8.05. I know
> there are two method to migrate. One is full database export/import, another
> is using the migration assistant provided by oracle. Is there any other
> method? What is the adv/disadv of these two method? We don't decide use
> which method now, please give some comment on these two method. TIA.
>
> Best Regards,
> Man
> ynmg_at_chowsangsang.com
Received on Thu Jan 14 1999 - 01:47:27 CST