Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: backup restore on 8.1.7

Re: backup restore on 8.1.7

From: Ronny Egner <RonnyEgner_at_gmx.de>
Date: Sun, 16 Jun 2002 12:11:36 +0200
Message-ID: <aehv9o.c4.1@rakane.dyndns.org>

"Mercilessming" <mercilessming_2000_at_yahoo_nojunk.com> schrieb:
> I have done the following exp system/manager full=yes this creating
> expdat.dmp now I want to restore this on another box how is the done where
> the tablespaces and users that are in the backup are created because imp
> system/manager file=expdat full=yes inctype=system fails because the users
> don't exist.

Iīm not sure, but I do think you need to create the account manually.

Why donīt you copy the tablespaces and recreates the control-files ?? This is very fast, especially on big systems.

Ronny Received on Sun Jun 16 2002 - 05:11:36 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US