Re: Migrate to 8.05!

Sorry, I'm babbler, I meant SYSTEM user, of course.

Karel Novotny

Jurij Modic wrote:

> 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 Fri Jan 15 1999 - 00:55:10 CST