Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: backup restore on 8.1.7
"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