Re: Migrate to 8.05!

From: Jurij Modic <jmodic_at_src.si>
Date: Thu, 14 Jan 1999 20:55:56 GMT
Message-ID: <369e4895.2620245@news.siol.net>

On Thu, 14 Jan 1999 07:47:27 GMT, Karel Novotny <knovotny_at_per4mance.cz> wrote:

>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.

There is no way you can export objects owned by SYS, so there is also no way you can import this user. DB catalog should already be there if you wan't to perform import. So there is no need for FROMUSER-TOUSER hassle if its purpouse would only be to exclude the SYS user from the import.

>Karel Novotny

Regards,
Jurij Modic <jmodic_at_src.si>
Certified Oracle7 DBA (OCP)

---

The above opinions are mine and do not represent any official standpoints of my employer Received on Thu Jan 14 1999 - 14:55:56 CST