Re: Cloning DB to different UNIX platform

From: Rick Denoire <100.17706_at_germanynet.de>
Date: Sun, 18 Aug 2002 23:38:01 +0200
Message-ID: <t640muslp88mvknd8u3gi2khg60fqs5bqq@4ax.com>

"Anton Buijs" <aammbuijs_at_xs4all.nl> wrote:

>A full export will create all users and create everything in the same
>tablespace as where it came from. When the tablespace does not exist, the
>users default tablespace is choosen.

Exactly. Since SYS is going to do the import, whose default tablespace is SYSTEM...

Well, at least if the tablespaces are created (which asumes that the corresponding paths exists on the target platform), then you should be right.

>Just remember that objects of SYS are not part of the export (including
>grants given on SYS objects).
>There are more users that are not exported, even in a full export: ORDSYS,
>MDSYS, CTXSYS and ORDPLUGINS. See 8i Utilities Guide, Chapter 1 - Export,
>paragraph Export Modes.

I did not mean that SYS objects would be exported/imported. So we agree here.

>Ok, I know lots of things can go wrong but as said: export/import is the
>only way to port a db to another platform.

Convinced.

Bye
Rick Received on Sun Aug 18 2002 - 16:38:01 CDT