Re: Transfer a complete database (8i)

From: Stephan Bressler <stephan.bressler_at_siemens.com>
Date: Tue, 3 Dec 2002 08:59:31 +0100
Message-ID: <asho79$mb8$1@news.mch.sbs.de>

Try
imp system/manager BUFFER=4096 FULL=Y FILE=/backup/expdat.dmp This will import all users beside sys. You might get some errors within the system schema (e.g. plan_table already exists).

You might want to increase buffer to 1mb in order to increase import speed. Setting sort_area_size to >1MB will speedup index creation.

Stephan

"Punu" <punupuatoro_at_NOSPAMfairesuivre.com> wrote in message news:asfbka$p3n$1_at_s1.read.news.oleane.net...
> Hello,
> I have to migrate my 8.1.7 database to a new server. I would like to
migrate
> the entire database (schemas, user defs, etc...)
> I have tried to do an export and an import on the new server but the user
> defs are not transfered :
> exp system/manager BUFFER=4096 FULL=Y FILE=/backup/expdat.dmp
> Is there a solution ?
> Thanks a lot.
>
>
Received on Tue Dec 03 2002 - 01:59:31 CST