Re: Moving entire 8.1.7 database b/t machines

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Sun, 8 Sep 2002 19:42:19 +0100
Message-ID: <3d7bb42e$1_3@mk-nntp-1.news.uk.worldonline.com>

"Anton Buijs" <aammbuijs_at_xs4all.nl> wrote in message news:alfckt$38p$1_at_news1.xs4all.nl...
> A full database import of a full database export recreates everything. It
> starts with the tablespaces, exactly as they where in the origin database.
> So datafiles will be created with the same names. When the directories do
> not exist, tablespace creation will fail. As a result, creating/altering
> users where the default tablespace does not exist will fail. Importing
> objects for users that do not exist will fail.....
> If tablespace creation failed you should create proper sized tablespaces
> before full import starts.
> Also be aware of the fact that nothing of the SYS schema is exported
> (because it is the owner of the database dictionary that is created when
the
> database was created).
> Grants given by SYS on SYS objects must be re-granted after import.
> There are other schemas for special database options excluded from full
> export/import, see the Oracle 8i Utilities Guide, Chapter "Import".
>

OP, please read, learn and inwardly digest. This is the full and complete answer.

Paul Received on Sun Sep 08 2002 - 13:42:19 CDT